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 - 1 of 1 Answers

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