Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to check if a table exists
- Thread starter fabry
- Start date
Not really an Access developer, but I would try the following.
When you process the OpenRecordset method against a table in Access Basic, it should return a discernable error, which may be interpretted as 'Table not found'.
A simple 'select count(*) from table1' should suffice to determine the tables' existance.
Ciao
AA 8~)
When you process the OpenRecordset method against a table in Access Basic, it should return a discernable error, which may be interpretted as 'Table not found'.
A simple 'select count(*) from table1' should suffice to determine the tables' existance.
Ciao
AA 8~)
- Thread starter
- #4
- Status
Similar threads
