Can I change a Linked Table with VB?
Posted on 2003-11-20
I have a database that is linked to an SQL server via FileDSN. However, my FileDSN is 'slightly' different from my users'. I thought I could put a version of their FileDSN and a version of mine in the same folder that gets distributed with my application's updates. Temporarily I name their File "FileDSN1" and use my own "FileDSN" to link the tables to the server.
Then before distributing the update, I could swap the file names and let their file be named "FileDSN" so the linked tables would work properly for them....
THE PROBLEM IS:
The table description holds the information from "my" file DSN because that is the one used to create the links.
CAN ANYONE TELL ME HOW TO:
Create a linked table with VB; using a specific fileDSN?
Change the properties on the Linked tables that are being distributed?
Not though VB, but just opening the linked tables normally, it tells me I can not save those changes. It seems like it might just be easier to create the links with VB, but maybe not.