Jim Dettman
jimdettman at verizon.net
Wed Dec 12 10:33:34 CST 2007
Ken Getz published an article on this long ago. Believe it was in Smart Access. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, December 12, 2007 11:05 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Classes In Referenced MDE Andy, There's nothing illegal about modifying a class that way. It even lived in Microsoft's own help files way back when in earlier Access versions. I think I first used it in 97 after I had found Shamil's DEEP article, but I don't think I got the technique from him. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Wednesday, December 12, 2007 6:45 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Classes In Referenced MDE 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com