Linking Project.adp to different SQL Server Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elka - 31 Jan 2004 20:06 GMT

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

Reply to this Message

Mary Chipman - 31 Jan 2004 22:35 GMT

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

>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

Reply to this Message