Creating and using an ms access database library of vb code.

[rogsonl]

I know you can compile an access database into a library and then use it.
Its been years since I needed to do this, and I don't remember how to go
about it.
I need to take existing code and place it into the library. This is a set of
code classes, not forms.
Thank you in advance for your help.
Leon

 

[david]

From a code window, go to the menu item Tools, References,
and add a reference to your library MDB.

All of the Modules, Functions, and Subroutines are exposed.

None of the Classes, Forms, or Reports are exposed (unless
you use Access 95). You need to add stub functions to access them.

If you use an application MDE, your library also needs to be an MDE.

(david)

 

[Tony Toews [MVP]]

I know you can compile an access database into a library and then use it.
Its been years since I needed to do this, and I don't remember how to go
about it.
I need to take existing code and place it into the library. This is a set of
code classes, not forms.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/