Re-establish linked tables in Access with VB: Help!

[DJP]

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.

[colin]

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 ???

[DJP]

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!!