Re: "FE Updater" and macro security

"Wayne" <cqdigital@xxxxxxxxxxxxxxx> wrote:

On my machine the old .exe file would start Access 2003 (the most
recently opened version). When I used the new .exe file it opened
Access 2007. Not sure why this is if it designed to work the same as
the old version.

Actually the way the utility currently works is it looks at the version of the
MDB/MDE. Then it goes down the registry keys from newest version to oldest looking
for a version of Access that is allegedly installed on your system. Then it executes
that version. So if you had A2000 and A2003 installed with an A2000 MDB/MDE it
would run A2003. I did this mostly because the assumption on my part was that A2003
would be inherently more stable.

However given the huge switching times with A2007 this is a royal PITA for the
developers. Now end users aren't likely going to have this problem because they will
very likely only have one version of Access installed.

So I'm thinking of what is the best way to handle this. Do I reverse the order to
look through the registry keys? Or do I add another entry line that has a default
version of Access? The latter approach would be better for ADPs as the utility
doesn't handle those gracefully at all.

By the way, thanks for an excellent utility.

Thanks for your kind words.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
.

Relevant Pages

  • Re: install old version of Access
    ... No, because MS use registry keys with the different version number in them, that is ... You need to add explicit path and file names of the appropriate versions of access to ... the version of Access used to create your MDB, MDE or MDA files and either reports ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: Option settings grayed out. Unable to complete repair.
    ... the performance hit on keeping the FE MDB/MDE isn't that bad. ... client running Citrix didn't want to copy the FE MDB/MDE to the Citrix ... Server so we ran them off the file server. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Re: Improving performance over the WAN
    ... can do to optimize MS Access for use over the WAN? ... If I can tweak one, ... Tony Toews, Microsoft Access MVP ... Microsoft Access Links, Hints, Tips & Accounting Systems at ...
    (microsoft.public.access.setupconfig)
  • Re: Vista and Access 2003
    ... My database is ... "selected collating sequence not supported by operating system". ... Tony Toews, Microsoft Access MVP ... Microsoft Access Links, Hints, Tips & Accounting Systems at ...
    (microsoft.public.access.dataaccess.pages)
  • Re: SQL Problem
    ... I don't keep track of names all the well in the forums. ... and in my current corporate environment there are no ... Tony Toews, Microsoft Access MVP ... Microsoft Access Links, Hints, Tips & Accounting Systems at ...
    (comp.databases.ms-access)