Q:

Meaning of MsysObjects values -32758, -32757 and 3 (Microsoft Access)

I'm quering the table MsysObjects for making a list of the objects in my database:
SELECT MsysObjects. Name, MsysObjects. Type
FROM MsysObjects
WHERE (((Left$([Name],1))<>'~') AND ((Left$([Name],4))<>'Msys'))
ORDER BY MsysObjects. Name;

I know the meaning of this values:
-32768 = Form
-32766 = Macro
-32764 = Report
-32761 = Module
1 = Table
5 = Query
6 = Linked Table

But what about -32758, -32757 and 3?  Where do they stand for?  Cannot find it on the web. 

A:

Type   TypeDesc
-32768  Form
-32766  Macro
-32764  Reports
-32761  Module
-32758  Users
-32757  Database Document
-32756  Data Access Pages
1   Table - Local Access Tables
2   Access Object - Database
3   Access Object - Containers
4   Table - Linked ODBC Tables
5   Queries
6   Table - Linked Access Tables
8   SubDataSheets
-- http://www.access-programmers.co.uk/forums/showthread.php?t=103811

A:

I'd tend to avoid mucking about with the system tables.  For one, temporary objects can show up there and confuse things.  To get the same information, you can use:
  CurrentDB.TableDefs
  CurrentDB.QueryDefs
  CurrentProject. AllForms
  CurrentProject. AllReports
  CurrentProject. AllMacros

That's the documented way to get the information.  Depending on undocumented system tables is not recommended.