question

TimothyAWiseman avatar image
TimothyAWiseman asked

Changing database names in an access application

If you have a Access Application linked to a SQL Server 2005 back end, what is the best way to change the database that the application is pointing to?

sql-server-2005microsoft-access
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Jim Orten avatar image
Jim Orten answered

Assuming you are linking to SQL Server 2005 using an ODBC DSN, you would just need to change your connection string in the DSN. Of course, the databases will need to have the same structure.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.