References to other Access databases

  • Thread starter Thread starter Michael Henry
  • Start date Start date
M

Michael Henry

I'm using office XP. I created a database x.mdb that
contains many class modules that are common to many
Access databases that I'm creating. My plan was to use
x.mdb as a library to reference from other Access
databases. However when I set the reference to x.mdb I'm
not able to declare variables with the classes that exist
in x.mdb in my current project. I can see the reference
and all the classes in the project explorer but can't use
them. Is there something that I'm missing.

Thanks in Advance,
Mike Henry
 
I figured it out.....I exported the class module in the
library to a text file. In the text file I changed the
following settings from false to true as shown.
Attribute VB_Creatable = True
Attribute VB_Exposed = True
Resaved the file.
Renamed my old class
Created a new empty class and imported the now changed
text file...

It works like a charm.
 
Back
Top