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