Search code examples
sql-serverms-accessadp

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

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.

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

Solution

  • 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