Test for missing object

  • Thread starter Thread starter Kevin
  • Start date Start date
Assuming you know the name of the object you want to find, and what type it
is (form, table, ...), you could query the MSysObjects table.

Example: Is there a local table named "MyTable"
Not IsNull(DLookup("Name", "MSysObjects", "([Name] = ""MyTable"") AND
([Type] = 1)"))

Type Ojbect
=-=- =-=-=-
1 Table
4 ODBC linked table
5 Query
6 linked table
-32768 Form
-32764 Report
-32761 Module
 
Back
Top