Andy Lacey
andy at minstersystems.co.uk
Sat Jan 23 13:12:50 CST 2010
Aah, yes it does. Sounds like the answer. Thanks everyone as ever. andy -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Sent: 23 January 2010 18:30 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Deploying Runtime Andy, The "Access 2007 Deployment Wizard" helps you create an MSI Installation .exe that installs the Runtimes for Access 2007, which you can run Access an 2002-2003 (and 2007) databases in. Does that help? WBR Robert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Saturday, January 23, 2010 12:29 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Deploying Runtime Hi Robert, thanks for the response Are you saying then that the "Access 2007 Deployment Wizard" version runs only with versions since 2003? I don't have 2003, in fact nothing since 2002. Where's that leave me? I also don't like the sound of "small issues with the wizard" though. This needs to just work. Andy -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Sent: 23 January 2010 16:42 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Deploying Runtime Andy, Can you Dev. the program In Access 2003? If so, You can use SageKey's new product called the "Access 2007 Deployment Wizard" and then get the free Access 2007 Runtime engine. That way, it's only the cost of the SageKey program, as no other programs are required. PS: They are still working out some small issues with the Wizard, but I believe it's your best solution. WBR Robert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Saturday, January 23, 2010 11:13 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Deploying Runtime Thanks Rocky I've been to the Sagekey site http://www.sagekey.com/installation_access.aspx . The Lite and Pro versions appear to be complete installers which bypass the need for Access Deployment but presumably you still nned the Access Runtime. But you still need Wise, right? Sorry to be dense but can you briefly take me through what I need and the steps involved in building an installation? I also note they refer to a single license for Access 2007. What if I'm using an earlier version of Access? Any idea? Andy -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 23 January 2010 14:59 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Deploying Runtime I have used the Wise/Sagekey combo for years with no problems. For that many installs it's probably well worth the bucks. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Saturday, January 23, 2010 6:42 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Deploying Runtime Hi all I know this has been kicked around before so apoogies for raising it again but time's moved on so the current situation may have too. Anyway, a quick look at the the archives didn't illuminate me. I'm proposing to take an app written in Excel and rewrite it in Access. Problem is that it will need distributing to 200+ machines Europe-wide, most of which won't have Access. Now I haven't used Access Runtime for about 15 years so am well out-of-date and could do with an update. I guess my questions are; 1. Any chance of me getting hold of whatever's needed (Access Developer Edition is it?) to create runtimes for older versions (Access 2000, 2002)? Have in fact just looked and there's a copy of "Microsoft Office 2000 Developer Tools for PC" on ebay in UK. Is that what I need? There's a copy of "Microsoft Office XP 2002 Developer 269-04560 COMMERCIAL" too. Is that the 2002 equivalent? If I buy either/both of these am I getting the right software? 2.If I get those is that all I need? I've seen a post on a forum which says, and I quote: "There can definitely be conflicts when installing ART to machines with full versions of Access. I use the 2002 ART and deploy those apps with the Wise Installer and use Sagekey scripts (www.sagekey.com) ... this script is designed specificially to install my application with the ART on a machine with an exisiting version of Access so that they can both co-exist. They're not cheap - the scripts are around $400 USD, the Wise installer runs between $400-$1000 USD - but they make your life a lot easier. Since switching to these scripts and the Wise Installer, my support calls for installation have been reduced to almost nothing; " Do others back up this experience? Id appreciate you guys' wise advice as always. Andy -- 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