martindavey
Programmer
I want to retreive the table names on a database (either Access97 or 2000) but am having trouble finding out the system table names that contain this info.<br>
<br>
Can anyone help ?
<br>
Can anyone help ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access 97 and 2000 System Tables - What are they called ?
- Thread starter martindavey
- Start date
- Status
The hidden system table is MSysObjects.<br>
<br>
Below is a query which will list the tables in you db :<br>
<br>
SELECT DISTINCTROW MSysObjects.Name, MSysObjects.Type<br>
FROM MSysObjects<br>
WHERE (((MSysObjects.Type)=6));<br>
<br>
WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=
<br>
Below is a query which will list the tables in you db :<br>
<br>
SELECT DISTINCTROW MSysObjects.Name, MSysObjects.Type<br>
FROM MSysObjects<br>
WHERE (((MSysObjects.Type)=6));<br>
<br>
WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=
- Thread starter
- #3
martindavey
Programmer
Bill Paton,<br>
<br>
Thanks for your remarkably swift reply.<br>
<br>
I don't unfortunately seem to have read permission on MSysObjects so I may have to find another way.<br>
<br>
Martin Davey <br>
from Basingstoke.
<br>
Thanks for your remarkably swift reply.<br>
<br>
I don't unfortunately seem to have read permission on MSysObjects so I may have to find another way.<br>
<br>
Martin Davey <br>
from Basingstoke.
- Status
Similar threads
- Locked
- Question
- Locked
- Question