Acc97 installation on working Acc03/Acc07 machines

[Dick Watson]

I'm about to inherit maintenance of an Acc97 database app. All of my
machines today are exclusively Acc03 or Acc07 and I've long since moved past
Acc97. What happens if I try to install Acc97 on one of these machines? The
obvious answer is "update the database and I'd love to do that, but the
client REALLY DOESN'T want to change. (Better is the arch-enemy of good
enough.)

 

[Rick Brandt]

I'm about to inherit maintenance of an Acc97 database app. All of my
machines today are exclusively Acc03 or Acc07 and I've long since
moved past Acc97. What happens if I try to install Acc97 on one of
these machines? The obvious answer is "update the database and I'd
love to do that, but the client REALLY DOESN'T want to change.
(Better is the arch-enemy of good enough.)

The conventional wisdom was that it was better to install multiple versions in
order (oldest first), but a few posters in these groups have reported installing
them in any old order with no problems.

 

[Dick Watson]

Which one ends up owning file associations, et al.? Last installed?

 

[Arvin Meyer [MVP]]

When you install Access 97 it will silently use the last run, as Rick
explained. Later versions are verbose, meaning that you will see a dialog
(which can be cancelled) while they reset all the associations. I do several
things for Access 97 installs to keep them from messing with later versions.

First, find the file msaccess.srg which will be in the same folder as
msaccess.exe. Rename it to: msaccess.srg.old (or anything else that you will
later remember should you need to name it back). Now open Notepad and create
an empty text file and name it msaccess.srg. Now we have fooled Access 97
into thinking it's not necessary to change associations.

Second, Find the SendTo folder (mine's at: C:\WINDOWS\SendTo) and create
shortcuts to each version. Now all you need to do is to right-click on a
file, choose SendTo, and send it to the version you wish)

 

[DL]

Ensure you custom install to a version specific folder (03 & 07 do by
default)

 

[Arvin Meyer [MVP]]

On this machine (Windows 2000) it is in the Windows folder. I just looked at
my XP machine and it has a SendTo folder as well. I don't have Access 97 on
my Vista machine. I'll email you a screen shot if you wish.

 

[Tony Toews [MVP]]

The conventional wisdom was that it was better to install multiple versions in
order (oldest first), but a few posters in these groups have reported installing
them in any old order with no problems.

Almost but not quite. You will get the no license error.
Bugs: License problems
http://www.mvps.org/access/bugs/bugs0013.htm
ACC97: AcLicn97.exe Available in Download Center
http://support.microsoft.com/?kbid=191224
ACC: "There Is No License" Error Message Starting Microsoft Access
http://support.microsoft.com/?kbid=141373

And I've been one of those too deliberately install in a randomish out
of sequence order these last four or six times.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

With multiple copies you pretty much have to abandon the
idea of opening Access files by double-clicking them. Open the desired version
of Access first and then open the file from within.

Access Version Checker which allows me to click on an MDB and it
opens up the appropriate version of Access for that MDB automatically.
Definitely a recommended product. http://www.aylott.com.au/accver.htm

Unfortunately he hasn't yet updated it for A2007.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Dick Watson]

I don't disagree, but must ask: what are you doing new work in?

 

[Rick Brandt]

I don't disagree, but must ask: what are you doing new work in?

Can't speak for David, but I have never developed in anything but 97. I have
every other version installed for testing and I distribute all my apps in both
97 and 2000 versions since that is all I need to be able to accomodate a user
with anything from 97 up to 2007 installed on their PC.

To me it is mostly a matter of being able to support the largest number of users
over the widest range of operating systems. I see no reason to develop an app
that immediately forces any of my users to upgrade their systems. Beyond that I
have simply seen nothing about *developing* in the newer versions that appeals
to me in the slightest. My internal company apps could all be developed in 2003
since that is what all users have, but I am just not interested in doing so
"just because".

With every new version since 97 I have been looking for some *compelling* new
features that I don't have to pay for with a myriad of irritations in other
areas. I'm still looking.

 

[Rick Brandt]

Access Version Checker which allows me to click on an MDB and it
opens up the appropriate version of Access for that MDB automatically.
Definitely a recommended product. http://www.aylott.com.au/accver.htm

Unfortunately he hasn't yet updated it for A2007.

Tony

I have heard of such utilities obviously, but I just have no need for them.
Since I only develop in Access 97 and convert up to support newer versions I
have virtually no cases where I want to open an Access file in anything other
than Access 97 and 99% of the time that will have been the last version I opened
so double-clicking produces the desired result.

 

[Paul Shapiro]

I've used Virtual PC to install older software versions in a virtual
machine, or for testing current applications on older OS versions. While
it's a bit more hassle to startup the program, it avoids potentially
"contaminating" your working machine.

 

[Tony Toews [MVP]]

To me it is mostly a matter of being able to support the largest number of users
over the widest range of operating systems. I see no reason to develop an app
that immediately forces any of my users to upgrade their systems. Beyond that I
have simply seen nothing about *developing* in the newer versions that appeals
to me in the slightest. My internal company apps could all be developed in 2003
since that is what all users have, but I am just not interested in doing so
"just because".

My biggest concern is security and the security patches which MS is no
longer supplying to Office 97. Yes, the chances of an exploit
utilizing an MDB/MDE is very low but that's not zero.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Rick Brandt]

My biggest concern is security and the security patches which MS is no
longer supplying to Office 97. Yes, the chances of an exploit
utilizing an MDB/MDE is very low but that's not zero.

Tony

My apps fall into two categories. Ones that use server back ends and ones
where security is not an issue. I just don't use Jet where security is an
issue.

 

[Arvin Meyer [MVP]]

Weirder still, I also have SendTo folders in my User folder. This machine
was never upgraded, either. Both folders have the same creation date. I
loaded Office soon after so I set the shortcuts up some time ago.

 

[Tony Toews [MVP]]

My apps fall into two categories. Ones that use server back ends and ones
where security is not an issue. I just don't use Jet where security is an
issue.

As David points out I'm concerned about various exploits against the
msaccess.exe and dlls and such. I do agree that anything with real
security should be on SQL Server or equivalent.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/