Linking Project.adp to different SQL Server Database

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top