sharing code between mdb's

message from thriveni on 4 Jun 2004
I have an access database that has a SQL server backend.
I need to create another database that is linked to
different tables in SQL server but has a lot of common
functionality with the current database that I have.

Is it possible to do code sharing across mdb's so that any
modifications in my VBA code in one mdb could reflect in
the other ? If not is there any other solution to this
problem ?
any help would be appreciated.
 
Tony Toews replied to thriveni on 04 Jun 2004
To add to Rick's posting see my Add-in Tips, Hints and Gotchas page at
http://www.granite.ab.ca/access/addins.htm

Tony
 
Rick Brandt replied to thriveni on 4 Jun 2004
You can make db1 a reference entry in db2 and then all code in db1 is
available to use in db2. Just go to Tools - References in the code editor
window.
 
anonymous replied to Rick Brandt on 4 Jun 2004
thanku very much. i will try that.

code in db1 is
in the code editor
 

Archived message: sharing code between mdb's (MS Access Database)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.