sharing code between mdb's

[thriveni]

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.

 

[Rick Brandt]

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.

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.

 

[Guest]

thanku very much. i will try that.

-----Original Message-----


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.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

 

[Tony Toews]

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 ?

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

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm