I have been developing an ADP in Access 2000. I recently
upgraded to Access 2002, but have continued developing in
the Access 2000 file format within Access 2002.
I just started using it on Access 2000 again, and I am

I'm fairly new to using ACCESS 2000 with MSDE on just a
LOCAL machine. Recently had a hardware failure and had to
move everything to a new PC.  The hard drive on the old
was still intact.  I reloaded OFFICE and MSDE from scratch

First, if MSDE 2000 is (local) on trusted NT credentials on my machine, I
can connect to it from Access just fine.  But later I may wish to experiment
with TCP/IP and/or Named Pipes.  To that eventual end, there is something
I'm noticing when my Access 2000 launches:  it's trying to ...

I am trying to use a SQL Stored Procedure as the rowsource for my listbox
and am having trouble passing a parameter to the stored procedure.  In the
rowsource property of the listbox I am using the following:
   Exec WL_Nxt_stp_sfrm_sp @crit_id = Forms!frmWatchlist!lstWLCriteria

I need to replace every instance of a word in our pagecontent table
with new terminology.  I need help a script that can be used to mass
replace every occurrence of a word in PageContent.  Doing a update
(UPDATE pagecontent SET contentshort = 'Deliverable' WHERE

I have a very simple piece of ADO code updating a SQL
table from Access.
Under some circumstances I need run the code twice,
consectively, with different data.

I need to create the connection to sql server by code.
Can i do this?
any help would be useful

MSDE has been installed in my server when running the
startup program of a 3rd party application. As
administrator of our network I have no problem to make a
link and to get from SQL the needed 3rd party tables in

I'm deciding my next application project, whether or not to use Access 2002
Project and SQL Server to develop.
Reason is I found KB-301693 "ACC2000: Form Error Event Does Not Return
Native SQL Server Errors in an Access Project". And it write "This problem

Hy everyone,
DB is SQL server 2000 sp3, 3,5 GB
Access 2000 ADP used to need a few seconds to open my SQL
server DB. Now with Access 2002 ADP as a front end to the

   I'm rebuilding a load of packages we lost (our backup didn't include the
packages!) and I'm trying to work out how we used to create the indexes on
access databases using the execute sql task within a dts package.
The following works on a connection set to an sql table but not ...

I've no experience writing code by using ADO before. I usualy uses DAO to
access .MDB database. I deciding to use Access 2002 Project and SQL Server
2000.
I'ld like to ask you. What happen if In .ADP code, I not reference to ADO

I have been developing an ADP in Access 2000. Midway
through development, I upgraded to Access 2002, but kept
the file format Access 2000 since all client machines
have Access 2000. After working on the application for a

I am currently running a departmental ADP with SQL Server
2000.  I have about 40 users, and my ADP is about 15 Meg.  
Our parent organization (which has about 200 users) is
considering using my application, but they are concerned

I have my database split into a front end and back end
database, would there be any advantage to convert the
back end to SQL on an SQL server, i.e. increase in
performance, what are disadvantages?...