Installing Access97 on a PC with Office2003

  ThorPet 16:10 20 Jul 2005
Locked

Does any know if it is possible to install Access97 on to a PC that already has Office2003 installed on it?

I have a compiled database that will only run on Access97, hence the problem.

I have tried removing the newer version of Access and installing Access97 but it doesn't appear to install and reverts back to the newer version!

  Rand Al Thor 16:13 20 Jul 2005

Have you tried to decompile the DB?

  ThorPet 16:16 20 Jul 2005

I wasn't aware you can decomile the db!

It was written for us several years ago and the original source cannot be found. If we can it would be great, as we could update it to a newer version of Access.

  Rand Al Thor 16:28 20 Jul 2005

Firstly, decompile the DB

"C:\Program Files\Microsoft Office\Office\msaccess.exe" "X:\YourDatabase.mdb" /decompile

Run this from the command line.

This is an undocumented switch, so keep a backup!
Secondly, if sucessful, convert to Access 2003 and recompile.

No guarantees, but it may get you out of a hole!!

  ThorPet 16:30 20 Jul 2005

Thanks! I'll give this try.

  olddick 16:33 20 Jul 2005

I was under the impression that Office 2003 was backwards compatible.

i.e. you can open old version files with 2003 but not 2003 files with an older version.

  Klof Ron 16:51 20 Jul 2005
  ThorPet 16:56 20 Jul 2005

Does anyone know if you can run Access97 on an XP machine?

  Klof Ron 16:59 20 Jul 2005

In the past I have run the full office 97 install on XP, including access 97 with no problems, Whether it will happily co-exist with access 2003 I do not know.

  ThorPet 17:04 20 Jul 2005

When I start Access97 on the XP machine I get an error message stating that

"A system error occurred, or there isn't enough free memory to start Microsoft Access. Close unneeded programs and try again."

Any suggestions anyone?

Thanks.

  Klof Ron 17:08 20 Jul 2005

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone