Sharing VB Classes with Other Databases (Alex Dybenko)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Alex -

Upon further review...

I was able to set the reference to DB2 from DB1.

The Explorer window shows DB2 project and there it shows up under
"References" as a "Reference to DB2.mdb" in the DB1project also in the
Explorer window.

So that looks great. By all indications the reference is set.

However, when I go to dim a class or module from DB2 they don't show up in
DB1.

So:
dim obj as DB2.myclass
set obj = new DB2.myclass

It gives me a "User Defined type not defined" error.

FYI, I tried setting a reference to the Northwind - which was successful.
The "Northwind" reference shows up in the object window. DB2 does not.

I'm using Access 2002, if that makes a difference.

Any suggestions?

Thanks again, Mark
 
Alex -

After playing a bit I am able to "see" the modules in DB2. We were able to
see the modules without using the Attribute suggestion.

Problem is the Classes are not available. I don't know how to apply the
Attribute suggestion you mentioned. Maybe it would help maybe it wouldn't
don't know.

Any other suggestions would be welcome.

Thanks, Mark
 
Problem is the Classes are not available. I don't know how to apply
Attribute suggestion you mentioned. Maybe it would help maybe it
Click to expand...

Apparently it doesn't work in 2003. So it should work in 2002,
but you may wish to reconsider your use of classes.

(david)
 
Hi,
perhaps you are right, I used classes last time long ago, and not sure this
really works in Access 2003

Mark, if you plan to build some kind of library for classes and functions -
I would recommend you to consider using VB6 activex dll - this works fine in
any access version


Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
 
Back
Top