Test for missing object

K

Kevin

How can I test for amissing object? i.e. table, form, etc?

Thanks in advance--again!
 
A

Allen Browne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top