|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 5th, 2004, 02:12 PM
|
|||
|
|||
|
SQL Query to find Table Names
In a past forum I read that it's possible to find table names in an Access db using the SQL query:
"SELECT Name FROM MSysObjects WHERE Type = 1" When I tried this on my personal machine (0r or a remote server) I received the error message: Microsoft OLE DB Provider for ODBC Drivers error '80040e09' [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MSysObjects'. How do I get read permission? Is there another way to query this information? Thanks
|
|
#3
February 5th, 2004, 04:35 PM
|
|||
|
|||
|
Access DB Table Names
Actually, no particular version... I'm using the query in an ASP script, referencing an [*.mdb] file, either using ODBC or via a DSN-less connection.
A.
|
|
#4
February 5th, 2004, 04:47 PM
|
|||
|
|||
|
I think that MSysObjects is for access within MS Access. I don't ever have problem with permissions whe using it within MS Access.
GOto http://www.dbforums.com/ and post your question there. Make sure they know you are trying to access it from ASP S-
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > SQL Query to find Table Names |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
