Privateer
Registered User.
- Local time
- Today, 16:24
- Joined
- Aug 16, 2011
- Messages
- 193
I have created a query using the system objects table to populate a temporary table of all the objects in the database, which works great. My problem arises when I try to run this in an access project, the system table does not exist, and it won't let me have a table or query in a project. My quick fix was to import everything from the adp into the accdb and my code worked. But I want a better solution. So I have two questions.
How can I open a project (adp) from my database (accdb) in a workspace or something similar? Assume the path and file name are provided.
Once opened, how can I loop through the tables, queries, forms, reports, modules, and macros, essentially all the objects and get their names, dates, and descriptions.
The descriptions are really another problem. By using tabledefs and querydefs I can get the descriptions for those, but I also want them for forms, modules and reports and there are no "defs" for those. So if you have a trick for this I would welcome it.
Basically anything that shows up in the navigation pane, I want to grab and store in another database table. Maybe I should be asking how the navigation pane gets populated?
As always, any help on this will be greatly appreciated.
How can I open a project (adp) from my database (accdb) in a workspace or something similar? Assume the path and file name are provided.
Once opened, how can I loop through the tables, queries, forms, reports, modules, and macros, essentially all the objects and get their names, dates, and descriptions.
The descriptions are really another problem. By using tabledefs and querydefs I can get the descriptions for those, but I also want them for forms, modules and reports and there are no "defs" for those. So if you have a trick for this I would welcome it.
Basically anything that shows up in the navigation pane, I want to grab and store in another database table. Maybe I should be asking how the navigation pane gets populated?
As always, any help on this will be greatly appreciated.