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?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
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.
No one has followed this question yet.
ODBC Connection to SQL Server failing from MS Access
Help in creating a SSIS Package
SQL time comparison query?
Convert Access Modules to SQL (store procedures)
Cannot open database.. requested by the login. The login failed. Login failed for user ‘User1′