Modify ODBC Connection string for a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have written procedure that should go through and for the TableDef objects
for linked tables from a certain DSN Change the server name in the connect
string to a new server that we have migrated Data to. Is there some setting
that I have to modify so can modify the connect string information for a
linked table?

Eric Lommatsch
 
Depending upon which version of Access you have, you can use the "Update
Linked Tables" wizard. I think it was introduced with Access 2003.

MH
 
Unfortunately the client has Access 2002 Installed. If they Had Access 2003 I
would try that.
 
The Other problem with that Idea is that even when I was able to find a
machine that had this wizard installed when I tried run the "update linked
Tables" wizard I ran into the same issue that is why I was trying to write
code to update these tables in the first place. Everytime I try to link
Access to this particular type of Data Source Access Crashes on me. This
happens whether I use an existing .MDB or a New .MDB. it is happening on any
system that I try to link to the type of data source from and if I try to
create a brand new instance of the Database engine that is powering this data
source the error is still occuring. If I try to use other types of databases
as the data source this error will not happen.
 
Back
Top