John W. Colby
jcolby at colbyconsulting.com
Thu Nov 20 12:20:44 CST 2003
Jim, If I were a VB6 programmer I probably would have attacked this problem ages ago. Since I'm not I don't routinely build DLLs. All I know is that when I try to use VBEErrorHandler I have to open the run dialog, and paste in a line of code that causes it to be registered. Thinking about it in that light, I have to assume I could run that same line of code in a batch file, properly modified with the name of the dll to register? Assuming that it doesn't annoy the user with an error message the 2nd and subsequent times I register it (the user runs the "download my app" batch file every morning) then it would be easy enough to start using something like redemption. In the end, inertia is the reason I don't (I've been reading Isaac Asimov's Physics book). If an object is at rest (Me re dlls) it takes an external force to put it in motion. <grin> John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim DeMarco Sent: Thursday, November 20, 2003 11:52 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Redemption DLL WAS: Poll: How many versions... There seems to be some stigma about using COM components with Access apps. I do it all the time for a number of reasons: 1. Keeps the db size smaller by moving large code blocks into the COM object 2. Compiled code is more secure 3. Compiled code runs faster 4. The COM object is a great way to store and reuse common libraries (no files to move around, no copy/paste of code) 5. I can use functionality that may not be a part of A97 (in my case) such as providing enums to functions or use of Interfaces 6. Copying and registering an ActiveX DLL is easy and simple. 7. I can even reuse certain functionality in web apps via ASP (my DataGrabber -name changed to protect the innocent- can be used in Access, VB, ASP or any COM compliant application). I guess if I keep going I could do a "Jim's Top Ten reasons To Use COM"! Jim DeMarco Director Product Development Hudson Health Plan -----Original Message----- From: Brett Barabash [mailto:BBarabash at tappeconstruction.com] Sent: Thursday, November 20, 2003 11:39 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Redemption DLL WAS: Poll: How many versions... OK, I give up. What's the big issue with installing a COM component on a user's machine? And a better question: If you don't use the redemption DLL, how do you bypass the security dialog? Or do you use the line a tech consulting firm recently handed us: "The email warning dialog is for your protection. It can't be bypassed" Uh huh... -----Original Message----- From: John W. Colby [mailto:jcolby at colbyconsulting.com] Sent: Thursday, November 20, 2003 6:05 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Poll: How many versions of Access are you runningononemachine? XPosted Stuart, The same reason I don't use it. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart Sanders Sent: Wednesday, November 19, 2003 11:06 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Poll: How many versions of Access are you running ononemachine? XPosted I have 97, 2000 (SP3) and XP (SP2) on my dev machine. I use outlook XP for email currently, but don't use automation. I had considered giving this a look: http://www.dimastr.com/redemption/ Which supposedly works around the security patch, but is a com component which needs to be installed on systems. Stuart > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. > Colby > Sent: Thursday, 20 November, 2003 10:23 AM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Poll: How many versions of Access are you > running onone machine? XPosted > > > I have Access97 and A2K on one machine, and AXP on another. > > I use Outlook automation to send email and the SP3 for Office2K breaks > outlook automation such that it asks for permission for every email > sent. SP3 fixed the screwup where XP breaks 2K but I simply can't > install it on my > dev machine. Thus XP on one, 2K on another. And I am NOT > happy to have to > do that! > > John W. Colby > www.ColbyConsulting.com > ---------------------------------------------------------------------------- ---------------------------------------- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the originator of the message. This footer also confirms that this email message has been scanned for the presence of computer viruses. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Tappe Construction Co. Scanning of this message and addition of this footer is performed by SurfControl E-mail Filter software in conjunction with virus detection software. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com **************************************************************************** ******* "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". **************************************************************************** ******* _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com