How to Retrieve data stored in Access system tables ? 1

[DaleWatson123321]

Does anyone know the method of retrieving data DIRECTLY from Access "system" tables (the tables Access uses internally to maintain the database) ???

Your help will be GREATLY appreciated.


...Dale Watson dwatson@bsi.gov.mb.ca

 

[Databaseguy]

Not recomended....

First, go to tools, options, view, check show system files. Now you can see the tables. Query them as you would any other table.

Better solution is to look into the Containers.Documents collections and VBA. They've got all the info you'll need to know about the DBs forms, tables, queries, reports, macros (scripts) and modules.

Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[DaleWatson123321]

Thanks, Ty. I suspected you would "come through" with a solution/recommendation. ...Dale