If a table exists then..........

[Tim]

In my database, the user has the option of linking to a
table in another database. I am trying to write an if
statement that will perform one set of actions if the
table has been linked and another set of actions if it
does not exist (which will involve creating the link).

Is there a function such as "if object exists" that I can
use?

 

[Tony C]

There is no "if object exists function available. However
if you use the correct criteria, you can search
the "MSysObjects" for the linked table
(research "FindFirst" and "FindNext" commands using DAO
Recordsets).

HTH


Tony C