What is the way for finding out whether a table exists in the Microsoft Access database?

Questions by RyanJames   answers by RyanJames

Showing Answers 1 - 3 of 3 Answers

Mike Reveile

  • Mar 14th, 2011
 

SELECT [MSysObjects].[Name]
FROM MSysObjects
WHERE ((([MSysObjects].[Flags])=0) And (([MSysObjects].[Type])=1));


This should list all the tables available that are not hidden or system

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions