Important: Access 2010 packager, Sagekey Alternatives

Posted on 2013-12-30
Last Modified: 2013-12-31
My firm is a long time user of Sagekey for Access 2003.
We are scheduled to roll out an Access 2010  project this week.  I ordered Sagekey 2010 online last Thursday and still hadn't gotten a download link as of today.
Finally called Sagekey and found out they are closed for the holidays and will not re-open until Jan2.  I know, bad planning on our part but we are we we are.
My project has to be installed Jan 2 so this is a serious issue.

I have never used the Access 2010package creator.  I would appreciate any information on how best to use it and  what it does and doesn't do.

The application we are developing is for a network.  The user machines do not have Access installed on them so the run time version of Access 2010 will have to be part of the install.

When using Sagekey, we put the installer on the network and gave all users a link to the installer on their desktops.  When the link was clicked Sagekey would install the application, compete with the run time of Access on the local machine.

The installer included an .ini fle that contained the location of the data on the server.  When the app was open on the local machine for the first time, we had a routine that would automatically link the files to the network.

This is the kind of functionality we are looking for.
Question by:mlcktmguy
  • 3
  • 2
  • 2
  • +1
LVL 21

Accepted Solution

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 175 total points
ID: 39746773
With Access 2010 you also have to deal with Trusted locations.  What SageKey offers that I have never seen anywhere else is there app launcher piece.  It handle the trusted locations. It is also the best one I have seen at  handling multiple version of Access installed on the same machine.

Bottom line is; AFAIK, There is not a complete alternative to SageKey.

I use INNO script to do the installs but that does not replace the App launcher.  I have built my own app launcher that does most of what SageKey's does.

Download here: Inno Installer Script (Like Sagekey)

Hosted here for Author: Darren Jones

This is an INNO Setup installer script.

With this script the initial download is far smaller in size for the end user that already has Runtime installed. he script has been put together using code snippets found on different forums along with bits I did myself, so thanks go to everyone.

This script will check to see if the user has either Access 2003, AccessRT 2003, Access 2007 or AccessRT 2007 installed.

If no access is detected, it will automatically download your Access 2003 runtime files from your web server and install them before continuing with installing your mde.

If access 2007 is detected, the end user will be prompted that functionality may differ (This can be changed)

If access 2003 is detected, the installation will continue.

The script will also add the relevent registry entries to eliminate the Security Warnings that normally show up when launching an .mde.
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 162 total points
ID: 39746780
Do the machines have  other versions of Access? This is the most difficult part, since running your 2010 app with the runtime will "register" the 2010 runtime as the default Access app, and all other Access apps on the machine will launch with that. Sagekey stops this by using a custom installer that fires the correct version of Access for the application, and when your app is finished, it will "reset" the machine to use the previous version.

Other than that, the packager will probably get you by. It can install the runtime alongside your app, and I believe it can install shortcuts, but that's about as far as it can go. If you need specialized installations, like installing and registering ActiveX controls, then you may have a difficult time.

You've probably already seen this, but here's a good place to start:
LVL 36

Assisted Solution

PatHartman earned 163 total points
ID: 39746900
You can try  It does a lot of what SageKey does but not all.
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.


Author Closing Comment

ID: 39746937
Thanks you for your responses.  Through some miracle, one of the Sagekey employees was either checking email or phone messages on their vacation.  I was sent an email with instructions to download the product, which I did.  I haven't built an installer yet but the interface looks exactly the same as 2003.

Props to Sagekey for going above and beyond the call of duty.  Their product has been great in deploying Access 2003 apps and I'm hoping it will work the same for 2010.

Props to EE responder also for trying to help me out of what looked to be a very dire situation.
LVL 21
ID: 39747142
You can try  It does a lot of what SageKey does but not all.

@PatHartman,  would you mind sharing which FMS product creates an installer package and installs the Access runtime if needed?
LVL 21
ID: 39747396
@mlcktmguy, that is great news. Glad to here SageKey can through for you.
LVL 36

Expert Comment

ID: 39747629
Total Access Startup.  I sent an inquiry to them this morning regarding A2013 and some features.  This is their response.
Thank you for your interest in Total Access Startup. The latest version of the product is designed to support Access 7.0, 97, 2000, 2002, 2003, 2007, and 2010. A version designed to support Access 2013 is currently in development.
We are planning to offer upgrade pricing for those users that have purchased one or more previous versions of this product. While no prices (or upgrade prices) have been set for upcoming product versions at this time, this is also something we will include in our notification to you when these products become available.
We do not yet have a date of release. However, since you have made this request, we will be sure to notify you upon the point it becomes available.
Total Access Startup does not offer a feature designed to setup trusted locations in the Windows registry. This task must be accomplished outside of Total Access Startup. The product is designed to support systems that are running multiple versions of Microsoft Access, however, it does not have the ability to suppress or prevent the re-initialization screen that you see when changing versions of Microsoft Access.
LVL 84
ID: 39747852
TAS is a "launcher", for lack of a better term, and not an installer. It would not install anything on the client machine, although it can update existing FE clients. It's a really cool tool, but it's not an installer.

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question