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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I get a list of objects & types for my db?

General

How do I get a list of objects & types for my db?

by  jgoodman00  Posted    (Edited  )
All of the objects in an AccessDB are stored in the MSysObjects table. Most of the columns are of little use, but two are very useful; namely the Name column & the Type column.

Using these two columns you can easily select all objects & see what type they are.

The Type column is an integer data-type, with the following values for common objects:

Types
Table = 1
Query = 5
Form = -32768
Report = -32764


So, to view all queries in your database, you can execute the query:
SELECT Name FROM MSysObjects WHERE Type = 5

And so on...

Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top