Access Frontend to SQL database

[jfrasier]

I used the upsize Wizard to create the SQL database and use my .mdb
for the frontend. Now we have moved SQL server to a new server. I have
figured out how to move the database, but I don't know how to tell
Access where the new location is.

Thanks.

 

[John W. Vinson]

I used the upsize Wizard to create the SQL database and use my .mdb
for the frontend. Now we have moved SQL server to a new server. I have
figured out how to move the database, but I don't know how to tell
Access where the new location is.

Thanks.

You'll need an ODBC link to the current SQL instance: Start... Control
Panel... Administrative Tools... Data Sources(ODBC) on my Windows version, it
may be somewhere else on yours.

You can then delete all the table links in your current frontend and use
File... Get External Data... Link, and select ODBC from the "files of type" to
link to the ODBC connection that you defined.

 

[jfrasier]

Thank you so much. That worked great.



Jane

You'll need an ODBC link to the current SQL instance: Start... Control
Panel... Administrative Tools... Data Sources(ODBC) on my Windows version, it
may be somewhere else on yours.

You can then delete all the table links in your current frontend and use
File... Get External Data... Link, and select ODBC from the "files of type" to
link to the ODBC connection that you defined.