I have just begun to create a database in adp and have
successfully connected with the server and created tables.
Now, I have created a form for one of the tables which
includes an OnClick event attempting to execute code with

I wish to loop through all my stored procedures to find any given
string contained in the procedure. For instance, using ADO I can loop
through tables and views to find af column of some given name.
I wish to do the same thing with all my stored procedures. This is

I downloaded a copy of MS SQL Server Books Online, but
when I try to install it, Norton AntiVirus gives me the
message "Malicious script detected", and recommends
canceling the install (which I do).

Hey all,
   When I am running queries through Access to SQL, all
the queries are fine, except those which have more than
one join(left or right).  One join is fine, but multiple

My colleagues and I at a small consulting firm have been
using Access for some time now to analyze large data sets
provided by our clients.  Each person working on the data
has one or more Access mdb applications with the data in

I'm moving the ADP SQL database to a new server.  Once
this is done, the old server will not exist.  Will I be
able to reconnect my ADP project to the new server.  
Thanks.

I receive this message "Data provider or other service
returned an E_FAIL status" when i try to read a table in a
Access project, linked to SQL Server.
Who can Help me?

I am currently running Windows 2000. Do I need to install Window 2000 Server
before I install SQL Server 2000? I have been having problems installing SQL
2000, and someone told me that this might be the problem.
Any help would be appreciated.

have written an SP with a parameter of
DECIMAL(5,2)
now trying to Call SP with Access 2000
adocmd.createparameter("RATE",addecimal,adinputparameter,???,35.24)

I have created a database in Access 2003 and then decided I should move it
to SQL. After going through the upsizing wizard my linked forms are not
working.
My subforms are not working anymore. Can anyone give me some steps to take

SQL2K backend Access 97 MDB frontend. I have a ComboBox whose Recordsource
is a SQL Passthrough Query. One of the returned fields is a Boolean value -
bit field in SQL Server. But I want it to display in the Access combo box as
either Yes or No. Currently Access displays 0 or -1. ...

I recently migrated one of my backends from Access to SQL.  I am wondering
how other companies handle monthend and yearend copies of the data?  In the
past, when it was monthend time I would create a copy of the backend and
copy it into a "month" folder.  I now have a monthly folder ...

My company has a large volume of information stored in a
Solomon Database on a Novell server.  Does anyone know if
Access can use the information from the Solomon DB to
create tables that can be used for Access reports or

I am using Access 97 with a major query/report/macro
database written by someone 5 years ago that has
disappeared from the face of the earth.  It generates
sales reports from Solomon software each month.

i chang the mdb database to sql with front end as adp. every things
workk fine except i have problem with one function. in my form i have
a drop-down box. whne user select the item from that drop down box the
value in other field inthe form automatically updated which i had down