954,595 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

checking whether a table exists in access.........

hi everyone!

i wanted to know the command to check whether a particular table exists in access or not............

for example, in sql server, we write ("select * from sysobjects where name='table1",con)

what is the equivalent command for this in access?????????


thanks..................

nice_true
Light Poster
28 posts since Sep 2007
Reputation Points: 10
Solved Threads: 0
 

try u r query in databases forum

greeny_1984
Posting Whiz
372 posts since Apr 2007
Reputation Points: 25
Solved Threads: 29
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You