As long as you have that, then in the code you can replace the old server name with the new server name and recompile.
There are multiple ways to improve this situation, however. One is to store the server name, database name, login id and password in a local table and then reconstruct the connection string at start up. Then try to make a connection to the server; if it fails, prompt the user for replacement values and store those.
Steve
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of j1eggert
Sent: Friday, November 21, 2014 1:24 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Need to Move MS Access DB (hardcoded to SQL Server) to another SQL Server
Yes, we have the source MDB.
Posted by: Stephen Conklin <stephenmconklin@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar