Linked tables with no associated tables in backend

[Guest]

I have cases where the front end show a table as linked, but there is no
associated table in the backend. (evidently, i removed the table from
backend but did not remove it from the frontend.). Is there a routine that
checks for such cases?

 

[Guest]

Try opening the front end.

 

[Guest]

air code

dim db as dao.database
dim tdf as dao.tabledef

set db = codedb.
for each tdf in db.tabldefs.
if tdf.connect <> "" then
tdf.RefreshLink
endif
next tdf


(david)