How to change the database location?

[Lisa]

Hi,

We recently moved the Access database to another server. The database is on
My SQL server. On client machine, we use ODBC to connect to the server.
However the Access file still remembers the old server after I changed the
ODBC settings? There must be somewhere in the Access that I can make change
to the new database server, but couldn't find where to change? Please advice.

Thanks in advance!

Lisa

 

[Jeff Boyce]

Lisa

Backup, backup, backup! Did you try "deleting" the table links and
re-connecting, using the new back-end?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Tony Toews [MVP]]

Hi,

We recently moved the Access database to another server. The database is on
My SQL server. On client machine, we use ODBC to connect to the server.
However the Access file still remembers the old server after I changed the
ODBC settings? There must be somewhere in the Access that I can make change
to the new database server, but couldn't find where to change? Please advice.

This information might also be in the DSN which should be in the
Control Panel.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/