Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
Can I get Access to show me a list of all the tables in a database

Thank
Malcolm
 
Yes - click on the Tables tab in the Database window! :-)

OK, I guess you meant programatically? If so, and assuming Access 2000 or
later ...

Public Sub ListTables(ByVal SystemTables As Boolean)

Dim aob As AccessObject

For Each aob In CurrentData.AllTables
If SystemTables Or UCase$(Mid$(aob.Name, 2, 3)) <> "SYS" Then
Debug.Print aob.Name
End If
Next aob

End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
Ensuring all fields are filled before posting. 2
Concurrency with Access 1
data justify 10
Format Date 6
Looking for a 13A plug-in Digital Timer to switch on at dusk . . . 9
VBA - retrieve data on last create named range from previous inserted named range 0
linking tables and relationships 3

Back
Top