469,915 Members | 2,599 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,915 developers. It's quick & easy.

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

Jul 19 '05 #1
4 3614
g wrote:
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

--
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.
Jul 19 '05 #2
g
the examples u show me are only tables.....how about queries in my database

Bob Barrows wrote:
g wrote:
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


Jul 19 '05 #3
g wrote:
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
--
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.
Jul 19 '05 #4
g
Thanks alot... i finally found a solution ....Thanks again

Bob Barrows wrote:
g wrote:
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


Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by ItsMe | last post: by
5 posts views Thread by Alan Little | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.