Finding the names of tables

[GusBrown]

Hi,

Assume that you have a .mdb file and that you know its name so you can set up a connection to it (I'm using VBScript/ASP).

Does anyone know how I can find the names of the tables in that file? Cunning SQL statements? Is there some sort of meta table which holds this data?

Thanks,

Gus

 

[Psychpt]

MSysObjects

 

[Quehay]

From the VBA Help in Access (Alt F11 then F1) with a search topic "table names":

Dim dbsNorthwind As Database
Dim tdfLoop As TableDef
Dim prpLoop As Property

Set dbsNorthwind = OpenDatabase("Northwind.mdb&quot

With dbsNorthwind
Debug.Print .TableDefs.Count & _
" TableDefs in " & .Name

' Enumerate TableDefs collection.
For Each tdfLoop In .TableDefs
Debug.Print " " & tdfLoop.Name
Next tdfLoop