Access Frontend to SQL database

  • Thread starter Thread starter jfrasier
  • Start date Start date
J

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.
 
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.
Click to expand...

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.
 
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.
Click to expand...
 
Back
Top