[quoted text, click to view]

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

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[quoted text, click to view]

:-)
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
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

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??

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

[quoted text, click to view]