Linked Table Manager

[carolynh]

I am using Access 2003 with developer extentions. When I package my database and try to run it from another pc, I get "ODBC -- call failed" even though I have created an ODBC connection with the same name I am using in my database, but if I go into the Database Utilities -> Linked Table Manager and physically link the tables, everything works fine. But I do not want the user to have to do this. I want it to be seamless once they run the install and install the database. Does anyone know how to refresh the linked tables without having to physically refresh them from the Linked Table Manager?
Thanks
Carolyn

 

[PHV]

Take a look here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;230588&Product=ado

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884