References to other Access databases

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top