[AccessD] How do I list all forms in an ADP (no MSysObjects)

David McAfee DMcAfee at haascnc.com
Mon Mar 31 19:41:17 CST 2003


In an Access 97 MDB, I can use the following SQL statement to list all forms
in an MDB:

SELECT MSysobjects.Name
FROM MSysobjects
WHERE (((MSysobjects.Type)= -32768))
ORDER BY MSysobjects.Name;

I know there are no local tables in an ADP, but somehow, somewhere, Access
must be keeping this information. Is there an equivalent way of doing the
same (either SQL or VBA) in an ADP?


TIA

David McAfee


More information about the AccessD mailing list