Configure ADP application to use a different database...?

Question

I have an Access Project (ADP) that is currently configured to connect to an SQL Server 2000 database on one server. I now need to migrate that server to SQL Server 2008 that will be on a different server.

I've not developed in Access for a while and have not done anything like this before...

Is it just a simple matter of modifying a connection string to point the application to the new database...?

Cheers!

Answer 1

Open the database window in Access. Then go 'file' - 'connection'. That gives you the option to select the server (item 1) & the database name (item 3) (Item 2 being a valid login).

-- http://www.tek-tips.com/viewthread.cfm?qid=1362659