check table/query exist help

[g]

Is there a method where by I could check for a certain table or query
exist in my access database file before I made query to it??

 

[Bob Barrows]

Is there a method where by I could check for a certain table or query
exist in my access database file before I made query to it??

You can use ADOX:
http://www.aspfaq.com/show.asp?id=2178
http://www.aspfaq.com/show.asp?id=2350
http://www.aspfaq.com/show.asp?id=2037

HTH,
Bob Barrows

 

[g]

the examples u show me are only tables.....how about queries in my database

 

[Bob Barrows]

the examples u show me are only tables.....how about queries in my
database

Well, you do need to do some research on your own ... a simple Google search
for ADOX and query (better yet, go to the source:
msdn.microsoft.com/library ) ...

In ADOX, saved queries show up as either stored procedures or views,
depending on what they do. You will find plenty of examples at msdn to get
you going.

HTH,
Bob Barrows