Automatically Connect Tables

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Tables 5
VBA - retrieve data on last create named range from previous inserted named range 0
Access Click in Table to Open Form 0
Access Dcount (multiple criteria) 3
Join 2 tables 1
create table from template table 0
Add Table Name as Field in an Append Query 1
Make table query: [Enter 1] AS Test 1

Top