One Module, Multiple DBs

[Michael Conroy]

Can I call up code in a module sitting in one database from an entirely
seperate database? Normally, I would import the module, but modifications
would require me to reimport it into the three other databases. Thanks for
your help.

 

[Brendan Reynolds]

Can I call up code in a module sitting in one database from an entirely
seperate database? Normally, I would import the module, but modifications
would require me to reimport it into the three other databases. Thanks for
your help.

Sure, you can add a reference to an MDB or MDE just as you can to a DLL
(Tools, References in the VBA editor). My personal experience has been that
this tends to be more hassle than its worth, and I prefer to re-import the
module - you just have to be disciplined about deciding that you will always
make any changes in just one of the apps, and import it from that app into
any others that use it, so that you always know which app has the most
up-to-date version. But your mileage, as they say, may vary.