|
 |
asp_databases thread: SQL for querying Access database schema
Message #1 by rico bernard <forlists2001@y...> on Wed, 14 Nov 2001 10:57:44 -0800 (PST)
|
|
Hello All,
I am creating a table dynamically in Access 2000 from
my ASP page. The name of the table is dynamically
generated in the code. What I would like to do is
write a SQL statement to query the database to see if
the table exists. I know how to do this using SQL
Server, but not using Access 2000. Can someone send
me or point me to the correct syntax? Thanks in
advance for your help.
__________________________________________________
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
Message #2 by Imar Spaanjaars <Imar@S...> on Wed, 14 Nov 2001 20:14:36 +0100
|
|
Hi there,
Take a look at ADOX, an extension for ADO.
You can find more info on ADOX at the following location: (wraps)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/daotoadoupdate_topic6.asp
Imar
At 10:57 AM 11/14/2001 -0800, you wrote:
>Hello All,
>
>I am creating a table dynamically in Access 2000 from
>my ASP page. The name of the table is dynamically
>generated in the code. What I would like to do is
>write a SQL statement to query the database to see if
>the table exists. I know how to do this using SQL
>Server, but not using Access 2000. Can someone send
>me or point me to the correct syntax? Thanks in
>advance for your help.
|
|
|
View Cart
