[AccessD] Classes In Referenced MDE

Andy Lacey andy at minstersystems.co.uk
Wed Dec 12 08:44:35 CST 2007


Only wish I knew what any of that meant Shamil. :-(

It's looking fine as is now anyway. If what I've done isn't legal I'm
relying on you all to keep schtum. :-)

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Classes In Referenced MDE
Date: 12/12/07 14:59


Andy,

Just wanted to note that another legal option could be to move your code
into VB6 ActiveX dlls...

....or even into VB.NET COM-exposed classlibs in the case your customers'
PCs
do have .NET framework installed...

....for the latter case there could be (quite some) overhead while getting
through CCW (COM Callable Wrappers generated by TLBEXP) and therefore for
the often used library functions moving code to VB.NET classlib(s) could
become inefficient....

--
Shamil

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Wednesday, December 12, 2007 2:24 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Classes In Referenced MDE

Whoa, amazing stuff as ever from you Shamil. Not sure if my bosses (client)
will let me use it though - will have to approach it gently.

I've got two questions. Firstly will it work on an MDE? Secondly am I right
in thinking that the Add-In would only be needed on the development machine
because it does a once-and-for-all change to the referenced MDB/MDE? So once
the add-in has done its work if the Fe and MDE are then copied down to a
user's machine will everything run ok without the user needing the Add-In?

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Classes In Referenced MDE
Date: 12/12/07 12:14


Hello Andy,

No legal way with Access 97...

"not legal" but used by several developers and worked well for them - here
it's:

http://smsconsulting.spb.ru/shamil_s/articles/cexposer.htm

Please take into account that if you use VSS then it will clear the flags
which can be set by the referred above add-in....

HTH...

--
Shamil

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Wednesday, December 12, 2007 1:42 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Classes In Referenced MDE

Hi Shamil
Thanks for this. Sounds like what I need except that I can't see how to set
the PublicNotCreatable property. Can you talk me through that? And before we
go any further I'd better admit this is A97 in case that blows this.

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Classes In Referenced MDE
Date: 12/12/07 11:32


Hello Andy,

This is a feature by design: you cannot have Creatable custom classes in a
library MDB/MDE.

Although you can have PublicNotCreatable custom classes (you can set this
property via custom class's properties window in VBA IDE, default value is
private) in your library MDB/MDE: they will be visible in FE but you can't
use New keyword to create their instances in FE - the hint/"trick" is to use
helper functions to create instances of these classes in library MDB/MDE....

There are also "dirty" tricks to make custom classes in MDB/MDE creatable
using New keyword in FE but I'd not recommend using them and therefore I'd
not write more on them here...

HTH...

--
Shamil

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Wednesday, December 12, 2007 12:49 PM
To: Dba
Subject: [AccessD] Classes In Referenced MDE

Hi all
I've been experimenting with creating a library of standard functions in
anticipation of a new project. Created MDB, imported modules with standard
functions, created MDE from that and then referenced that MDE in my FE. All
fine and dandy.

Then imported into my library a class module. Recreated MDE. This time
though my FE fails to compile because it doesn't like my Dim of a new
instance of the class - unknown user-defined type. Question is am I doing
something wrong or is this a limitation, ie that class modules must reside
in the FE from which they're called. One of you class experts is sure to
know this one.

--
Andy Lacey
http://www.minstersystems.co.uk

________________________________________________
Message sent using UebiMiau 2.7.2

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2




More information about the AccessD mailing list