Linking Project.adp to different SQL Server Database

G

Guest

While using an Access project(Acc2000) I would like to link the
project to another database (same Server) that is identical according to table/views etc
In this way it is easy to swap production and test
How can I easily swap database because there is no way to link tables,
they are part of of the project
 
M

Mary Chipman

An ADP can only link to one db at a time. You can either re-connect to
the other db, or you can create views or stored procedures in one of
the dbs that reference objects in the other (use the
database.ownername.objectname syntax).

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer data from any mdb file to sql server? 1
Copy Access tables to Access Project with SQL Server tables 5
SQL Server 6
Table Def “Connection†info (Database Name) 4
Linking SQL Server tables 5
CONNECT MICROSOFT ACCESS TO MICROSOFT SQL SERVER 2008 1
How to Upgrade SQL back end of Access linked tables. 7
link a table using an .ADP access application 1

Top