I have both Access2007 & Access2003 on a Vista Ultimate machine.
If I open 2007 after having a 2003 .adp open, the 2007 configuration runs.
Same going the other way.  After working in 2007, if I open a 2003 .adp,
the 2003 configuration runs.

I'm just wrapping back an ADP project, but am faced with dilemma.
Here's the situation.
* Have a test server: ServerA
* ADP compiled to ADE to use ServerA

I have been working on upsizing an Access 2000 data structure to SQL Server
2000 using the Upsize Wizard in Access2k2/XP.  I have been developing the
data structure (no data yet) in Access, upsizing, reviewing the results,
tweaking the structure in Access, then repeating.

MS Access 2003 SP2 - SQL Server 2000 SP4
Background: Same Access VBA code works fine on 15 other forms. But a
form backed by the following view gives concurrency problems. IE, says
another user has modified the record and gives options to "Save

In my SP I am opening a VIEW as a CURSOR. The view returns all NULLs
if there are no records in the underlying table. This breaks my SP
namely - cannot SELECT INTO @intVar when the actual value is a NULL.
It would be perfect if I could convert all NULLs to zeros.

I'd like to have ComboBox 1 drive what is displayed in ComboBox 2.
I can use forms and even subForms & Reports, and use stored procs for
everything
using the .InputParameters property

Summary of the problems surrounding ADP SQL and TRIGGERS
Every trigger starts with
AS
SET NOCOUNT on

I am developing a routine that needs to grab the SQL statement for
each database object in the current project (ie the SQL statement for
each stored procedure, view, and function).
This is a sample of how I'm iterating through the objects in VBA:

I am currently writing an ACCESS ADP app which uses SQL Server 2005
Express Edition.
users have to login to the app/database and I am setting the current
application-connection:

I had a database that the user opened a mde front end with a few front end
tables but most of the data was linked to a mdb backed. The backend was on a
shared drive on the network.  Do to the size of the table the company wanted
to move the backend to Microsoft SQL 2005.  This ...

I am writing an ACCESS 2003 ADP app which connects to a Sql Server
2005 Express Edition database. to enable my user to login to the
database, I ask him to enter the name of the server (instance),
database, username and password.

I am trying to decide whether it is best to use an ADP or MDB structure with
Access 2007 when upsizing from an existing all-Access mdb to SQL Server.
The more research I do, the more conflicting opinions I find.
For example, I had understood that an MDB will pull an entire table ...

I just installed my upgrade MS RMS (POS software) that is using the New
SQL -  My access 2003 will not allow me to do Queries anymore. Do I need to
upgrade to 2007? or do I need to update the software?  Any ideas would be
appreciated.

hello..
i have a complex  situation here,
i'm very new in programming
i try to make an application in Access project, some thing like book

hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh