Hello:

I have just picked up a bit of work on an Access 97 system. In
British Columbia, we have a change in the way that the taxes will be
computed coming up July 1.

Fortunately, I still have my Windows 98 box on my desk. I have
not used it in months, but I have to now as I can not get Access 97 to
install on my XP box. There is an installation error about not being
able to create system.mdw. (I am then told that the installation
completed successfully.) Access 97 will then not start because of the
missing file.

Does anyone know what I have to do to be able to run Access 97
under XP?

Sincerely,

Gene Wirchenko

On Thu, 24 Jun 2010 20:18:16 -0700, Gene Wirchenko <genew (AT) ocis (DOT) net>
wrote:

A97 can definitely be installed on XP.
I might rename all occurrences of system.mdw and try the install
again.

-Tom.
Microsoft Access MVP

On Thu, 24 Jun 2010 20:19:25 -0700, Tom van Stiphout
<tom7744.no.spam (AT) cox (DOT) net> wrote:

Good.

There were none. I did retry the installation (uninstalling
first) to the same effect.

I also tried copying the system.mdw from my 98 system, but when I
start Access 97 on my XP box, Access 97 blows up with an out-of-memory
error. Odd that: my 98 box has 192MB of RAM, and my XP box has 1.5GB
of RAM.

[snipped previous]

Sincerely,

Gene Wirchenko

"Gene Wirchenko" <genew (AT) ocis (DOT) net> wrote

The memory error is a common one. You need to ensure you've got the latest
upgrades to the Jet Database Engine. See
http://support.microsoft.com/kb/161255 for details.

Unfortunately, I'm not sure where you can get them anymore, as I don't
believe they're available through Windows Update.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

Checkout Tony's Access page at http://www.granite.ab.ca/accsmstr.htm

I have run Access97 on everything from Windows98 though WindowsXP, It will
not run under Windows7 except in XP mode.

Two things to look for and change, before installing.
Search for the font file HATTEN.TTF, if found; rename it.
Search for other versions of Access, MSACCESS.exe, if found; rename it.

Install Access97, (I like to install it in a new Office97 folder instead of
the default, just to keep it separate for newer versions)
Run the check for service pack 2b, "SR2CHK.EXE"
If needed install Office97 service pack 1, "SR1OFF97.EXE"
If needed install Office97 service pack 2b, "SR2BOF97.EXE", (You will need
the Access97 disk to install the service pack)
If needed Install Jet service pack 3, "Jet35sp3.exe"

If new version of HATTEN.TTF existed, locate the newly installed HATTEN.TTF,
delete or rename it
Restore the original HATTEN.TTF
Optionally Restore the original MSACCESS.exe if you want to run both
versions of Access.

Access97 should now run.

"Gene Wirchenko" <genew (AT) ocis (DOT) net> wrote

On Thu, 24 Jun 2010 20:18:16 -0700, Gene Wirchenko <genew (AT) ocis (DOT) net>
wrote:

I'm running A97 fine on Win XP but then I'm running as administrator
which I should not be. And it sounds like you're running as a regular
user.

If I recall correctly in A97 the system.mdw file is placed in the
Windows System folder. However regular users can't update any files
in the Windows System folder. So you need to place that file
somewhere else. Toruble is I don't remember what the solution is.
And my memory may be faulty too.

You might night to see if the system.mdw file was created or create a
new system.mdw file and jonn to that file using the work group
admniistrator. But I may be missing some steps in here.

Tony

"Tony Toews" <ttoews (AT) telusplanet (DOT) net> wrote

I use Access 97 under WinXP, and I'm not Administrator on my machine.

Correct.

Don't believe that's generally the case. Definitely I can write to that
folder (and given how locked down our machines are, I can't imagine that we
would have relaxed built-in security rules anywhere! And given that a
System.ldb file is opened whenever you're using the System.mdw file, it
really wouldn't make sense that the file would be written to a
write-protected folder.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

On Fri, 25 Jun 2010 07:25:10 -0500, "paii, Ron" <none (AT) no (DOT) com> wrote:

Thank you for the above. Access does now run, but SR2b was
rejected with

Microsoft Office 97 SR-2
The Microsoft Office 97 SR-2 patch cannot be applied to your computer.
Either Office 97 is not installed on this computer, or there are files
from multiple versions of Office 97 on this computer. Try installing
Office 97 or running the latest SR-1 patch to correct the problem. Or,
contact Microsoft Technical Support for further assistance.
OK

Office 97 is installed on my computer, and I have only one
version of it installed. I redownloaded the SR-1 patch to compare to
the one I installed, and it is the same one.

Any idea what is happening here?

[snip]

Sincerely,

Gene Wirchenko

"Gene Wirchenko" <genew (AT) ocis (DOT) net> wrote

Did you run SR2CHK.EXE to check if your are ready for SR2b?

I have never had issues with SR2B after a clean install of Access97 if
SR2CHK passes.

You could try installing "SR2AOF97.EXE" before SR2B.

Gene Wirchenko <genew (AT) ocis (DOT) net> wrote in
news:ei7826p457os9uoe44uhc9f129mgn29p0t (AT) 4ax (DOT) com:

I'm running A97, A2000, A2003 and A2007 on this WinXP box.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/