Sharing VB Classes with Other Databases (Alex Dybenko)

[Mark]

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 Dybenko]

Hi Mark,
I am not so familiar with classes in library mde, but AFAIR - you have to do
some tricks in order to have it visible. Look here:
http://alexdyb.blogspot.com/2005/01/how-to-hide-procedure-in-library-mde.html

I think you have to set:
Attribute VB_Exposed = True
using method in a link provided

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

 

[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

 

[david epsom dot com dot au]

Problem is the Classes are not available. I don't know how to apply

Attribute suggestion you mentioned. Maybe it would help maybe it

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

(david)

 

[Alex Dybenko]

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

 

[Mark]

I agree!!!!

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