In Sql Server you can select all the tables by using sp_tables - how can 

you do this for an access database..?



Thnks in advance



Aruna

Microsoft wouldn't support this approach (since it relies on an internal

system table, the structure of which they may one day want to change) but

this should work:



SELECT MSysObjects.Name, MSysObjects.Type

FROM MSysObjects

WHERE (((MSysObjects.Type) In (1,6)));



A type of 1 signifies a local table, 6 means it's linked.



To see this and other system tables, check the "System Objects" box on

Tools->Options->View



hth,



-Roy





-----Original Message-----

From: aruna.koya@d... [mailto:aruna.koya@d...]

Sent: Wednesday, February 14, 2001 5:58 AM

To: Access

Subject: [access] Access Query: Selecting all table names from database





In Sql Server you can select all the tables by using sp_tables - how can 

you do this for an access database..?



Thnks in advance



Aruna

Do you know what SQL query will test if a field is an autonumber field?



Thanks in advance..

Aruna



Westward Communications Group