[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?


More information about the AccessD mailing list