Drew Wutka
DWUTKA at marlow.com
Fri Nov 21 14:51:09 CST 2003
I hear ya. I'm in the same boat. When dealing with Access, it's a rare rare rare day when I have to create a runtime version. 99.95% of the Access stuff i work on are .mdb's (or .mde's) that run on full blown versions of Access. No install necessary. To me, that is part of the charm of Access. No need to install anything anywhere, just copy the file. On the other hand, I deal with VB quite a bit, and that's a different story. With VB, you are faced with installing the VB runtimes already, so adding other components into the install is just part of the mix. However, what I have found to be the best of both worlds is ASP/VB/Access. Access (Well Jet) as the backend. ASP as the FE, and VB in the middle as an ActiveX .dll. The real beauty of that system is that if I think things through when I am building it, I can make the ActiveX .dll's interactive with each other. In a corporate environment, it is very handy to just reference a pre-existing .dll on the IIS server, and use it with a new application. Loads of fun! Drew -----Original Message----- From: John W. Colby [mailto:jcolby at colbyconsulting.com] Sent: Thursday, November 20, 2003 12:06 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Poll: How many versions of Access are yourunningononemachine? XPosted Charlotte, >Since we install our applications on user systems, it hardly seems valid to quibble about installing the Redemption dll as well. The problem with that argument is that I don't use runtimes. Thus an "install" is nothing more than running a batch file that builds a directory, downloads my framework to the windows dir and the app to it's dir, then starts the app. Installing a dll means registering it (doesn't it?). If I could simply copy it somewhere and use it I would quiet my complaints considerably. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Thursday, November 20, 2003 11:28 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Poll: How many versions of Access are yourunningononemachine? XPosted Stuart and John, Since we install our applications on user systems, it hardly seems valid to quibble about installing the Redemption dll as well. We use redemption and find it very effective since it bypasses the MAPI calls that have been such a security problem and uses Extended MAPI instead. Charlotte Foust -----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 > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Joe Hecht > Sent: Wednesday, November 19, 2003 8:36 PM > To: AccessD; ACCESS-L > Subject: [AccessD] Poll: How many versions of Access are you running > on one machine? XPosted > > > I have one machine and Access 97, 2000, XP and 2003. > > The OS is win XP. > > How many people have more than one version of Access on one machine. > Which versions? What are most clients still using? > > Thanks > > > Joe Hecht > > Los Angeles CA > > > > > _______________________________________________ > 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 > _______________________________________________ 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 _______________________________________________ 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