Click here to Skip to main content
14,331,308 members
Rate this:
Please Sign up or sign in to vote.
See more:
How can I determine that a new table already exists in database through query?

Please help me to supply right access query, not design wizard.
I wait for help.
Posted
Updated 16-Nov-11 19:51pm
v2
Rate this:
Please Sign up or sign in to vote.

Solution 2

MS Access databases contain the system table MSysObjects you can use to query for the presence of tables.
SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Name = "TableName";
   
Comments
Mehdi Gholam 17-Nov-11 2:00am
   
5'ed
André Kraak 17-Nov-11 2:10am
   
Thanks.
Rate this:
Please Sign up or sign in to vote.

Solution 1

   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100