Cannot expose a class

[Francesc Hervada-Sala]

Hello NG,

I have an Access 2000 database with some classes that I want to expose,
so that other databases can use them without having an own copy of the
source code. At this newsgroup I was told to export the class modules as
text files, change the property VB_Public to True, and then reimport
them. I have done it, but it does not work.

After re-importing the class module the property "Instantiate" of the
classes get the value "public - not creatable". When I open the other
databases, the classes are in fact visible (the statement Dim a As
MyClass compiles without error), but I cannot create a new object: the
statement Set a = New MyClass fails at compile time.

I would appreciate any help very much!


Bye,


Francesc

 

[Paul Overway]

See http://www.mvps.org/access/modules/mdl0034.htm

Follow instructions EXACTLY for second method. I have a library DB
containing several classes exposed using this method and it works great in
97, 2000, and 2002!

 

[Francesc Hervada-Sala]

Hello Stephen,

Public Function CreateSample_Class() As Sample_Class
Set CreateSample_Class = New Sample_Class
End Function

thank you for your suggestion! I will use this, if in the future the
method at http://www.mvps.org/access/modules/mdl0034.htm does not work
any more (as it is an undocumented feature, this could probably happen).

Bye,

 

[Francesc Hervada-Sala]

Hello Paul,

See http://www.mvps.org/access/modules/mdl0034.htm

Follow instructions EXACTLY for second method. I have a library DB
containing several classes exposed using this method and it works great in
97, 2000, and 2002!

thank you very much. I did not really do exactly the same. I did not
re-import the file the correct way. I'm sure now it works!

Regards,


Francesc