Printable View
I have an access database that has tables linked to tables in two further access databases.
What I cannot work out is how to re-establish the links to the tables after installation so that the paths to the databases/tables is correct.
Is there a way to call the linked-table manager functionality from VB, or any other ideas on how I can do this.
You could call your tables from each of the databases seperatly into VB6 using the data environment to establish the connections to the individual databases. Then re-create your queries calculating the data from within VB6. What are you trying to achieve ???
The tables that I have split out as linked tables are ones which I need to be able to send updates to.
The main database has 30+ queries in it that reference the linked tables (about 50 divided in two databases) in the database.
I want to be able to check that the linked tables are still attached OK, and if not re-establish the links. I was hoping that there would be a way of doing this without having to go through deleting all the linked tables, and then making the links again.
Unfortunately I thought this would be easy, but I guess this breaks the first rule of programming!!