Count Linked Tables and Reattach?

[Bucky]

I have database structure that involves a front- and back-end with the
forms, queries, macros, etc in the front and the data tables in the
back-end. The tables in the front are LINKS to the real tables in the
back end. Let's call them Stats.mdb (front) and StatsData.mdb (back).

When I open Stats.mdb, I want it to count the number of linked tables
and determine if it's 12. If it's not 12, I want it to delete all the
linked tables and relink them.

How can I do it? Is it possible? What kind of VB code?

Thanks for any input!

Jim

 

[Wayne Morgan]

http://www.mvps.org/access/tables/tbl0009.htm

You will find code for relinking tables at the above address. To count them
number of linked tables, go through all of the tables and see how many don't
have an empty .Connect property.