[AccessD] Open an Access DB from within the main DB

Arthur Fuller fuller.artful at gmail.com
Mon Oct 10 20:16:58 CDT 2022


I think I've asked this before, and received an answer, but can't find it.
Here is the scenario:
I have some code that processes the objects in a database, such as count
its forms, tables and queries, plus more complex things such as use the
TableDefs to list the Fields and some of their properties, and so on.
What I do not want is to have to copy this code into each database I want
to process. I want this database to select a database using FileDialog, and
then I want to open the selected database in hidden mode, then do its
thing, and close the selected database when the processing is done. Most of
this code is written, but I can't figure out how to open the selected
database from within this toolbox database.
I've done some Googling but failed to come up with anything. Any
suggestions or solutions?
Thanks.

-- 
Arthur


More information about the AccessD mailing list