I am in the process of testing a SQL Server Express 2005-Access 2007
ADP initially created on a single-user desktop in a multiuser
environment, but cannot connect a test client.
This is the specific problem:

Help plz,
i was working on adp project, and i realised a problem on my laptop and
closed microsoft access and saving my adp file, after restarting the laptop,
i tried to open the file again but it didn't anymore, it gave a message "not

I don't know what I have done to the SQL Server but I just locked myself
out. I cannot connect to it via Access from a desktop but, I can connect to
it using Access from the server itself (w2k).
It acts as if I'm blocked by a firewall. However, the web application using

Greetings all.  I am using ADP 2003 and SQL2K.  I have a form with a stored
procedure as the record source.  There is a search form where users type in a
job number that is passed to the procedure to bring up the record
corresponding to that job number.  The job number is the PK ...

I want to be able to define and manipulate custom office properties
for an ADP file from VBA code within the ADP.  Now, I can
interactively right click on the file, choose properties, choose
custom, and create a custom property and value.  The property and

I 've an access 2000 adp connected to an sql server 2005 database.
In access, in the listview of the stoked prodedure i see "Ps_TEST;1 (DBO)".
The real name, that i can see in sql management, is "Ps_Test (dbo)".
Why we get ";1" ? This problem concerns all stocked procedure.

how to print group/user permissions  ?

I have an adp, lets say it linked to SQL database called SQL_A.
In another SQL database, SQL_Staff, there is a list of staff.
I need to look up that list in my adp. However, as an adp can only link to
one database, how do I get around this?

I am using and Access 2000 database front end with SQL Server 2000.
When I start to edit data in a text field on a form (the form is bound
to the table) it disappears.  Does anyone have any idea what may be
causing this?  I have verified this behavior with different tables and

I recently got an Access 2002 ADP that uses SQL Server 2000. I noticed that
all forms are unbound. After some research it looks like there is (was ?) a
known problem about uniqueidentifier columns.
For example a bound Access form will create default values even for nullable

I have an ADP which run very well under SQL 2000. I have recently replace
the SQL 2000 with SQL Express 2005. My ADP now cannot connect to SQL Express
2005.
Could anyone advice?

I am just learning SQL server - I'm going through these videos from a company
called Learn Key - 18 videos - it's the most , comprehensive, educational,
interactive, user friendly learning materials I've ever seen.  A-nyway, what
is the big advantage with SQL server ?  MS Access ...

Using the standard Data Link Properties Connection dialog there is option on
the Advanced Tab to change the connection timeout from the default 30 seconds
to another value.
Occasionally, depending on the database workload and volume of data, I have

Hi everyone! I need to open an ADP project through automation (I know how to
do that). However, when I do it all the scripting stuff starts executing
(startup forms, autoexec macro..). I would like to bypass these methods and
open the adp file to do my stuff. What I would like is a ...

I have an ADP in Access 2003 that we've been running against SS 2000 on
a win2000 server for a couple years. It's got a bunch of vbscript
behind everything.
Recently, we moved the databases to a win2003 server with SS2005. Most