moving SQL database to new server

  • Thread starter Thread starter Timo
  • Start date Start date
T

Timo

I'm using Access2000 ADP as front-end to SQLServer 2000 database. The
database is being moved to another server. Where do I tell Access the new
location for the SQL database? I don't see a Files/Connection option on the
menu.
Thanks
 
Normally, you open the Connection dialog from the File
menu. You can force the dialog to open by entering
DoCmd.RunCommand acCmdConnection
into the Immediate window in the VBA editor.
You can also set the OpenConnection property of the
database in the Immediate window to the new server. You
can use the following in the Immediate window (replace
variables with your server, userID,passwrd, database
name):
Application.CurrentProject.OpenConnection "Provider=SQLOLE
DB.1" & _
";Persist Security Info=True" & _
";Data Source=" & strServer & _
";User ID=" & strUser & _
";Password=" & strPwd & _
";Initial Catalog=" & strDB
 
Back
Top