Linked tables

[Lisa R.]

Dear Access experts,
I must write VBA sub or function that
check connection of front-end and back-end
tables in two steps:
A: If all Linked tables have a Back-End
that exists. If no back-end, must the
linked table name be displayed in a
message box.
B: The code must also loop through all
Back-End tables (I can filter system
tables) and find all tables that do
not have a linking Front-End table.
If no front-end table must I get the
back-end table name in a message box.

Lisa

 

[Allen Browne]

Lisa, take a look at the RefreshLinks code in Solutions.mdb

The file is on the Access 97 installation CD, or you can download it from:
http://msdn.microsoft.com/library/officedev/bapp2000/mdbdownload.htm

A linked table has something in the Connect property of the TableDef.