Automatically Connect Tables

[Nigel]

I have n access database which is split with the tables in one database and
the queries etc in another,

I have created a table called zztables and it is populated with the names of
the tables that are linked


I would love to be able to use code to delete all the linked tables and then
run through the records in the zztable table and reattach the tables listed
in it, the field name in zztables is ltable

Is this possible
thanks

 

[George Nicholson]

You don't need to delete tables, just refresh their links (aka, the
tabledef.Connect property):

http://mvps.org/access/tables/tbl0009.htm
Relink Access tables from code

HTH,