Auditing Utility for MS Access 2003

D

djyip13

I am trying to find a utility that will inventory the objects (tables,
queries, forms, etc) within a MS Access database. For the tables, I'd
like to know if they are internal or linked, and for the queries I'd
like to know what type of query it is. Is there such a utility? Any
help would be greatly appreciated.
 
D

Daryl S

You can find this information in the MSysObjects table. This table is
normally hidden, but you can 'Show System Objects' to see it. The 'Type'
field contains the object types - 1 for local tables, 6 for linked tables,
and 5 for queries. The name of the object is in the 'Name' field. To find
out what type of query you want, look in the 'Flags' field. 0 is for Select
queries, 64 for Make Table queries, 32 for Delete queries, and 48 for Update
queries. You can build a query from this table selecting only the objects
you want, as this contains the other object types you did not ask about.

Make sure you only read this table - do not change anything!
 
Top