Need to go back to Access 97 from a 2000 install

[I should be working]

Hello.
I recently upgraded a friends Office 97 to 2000 on her XP SP2 computer.

I installed the Office Professional 2000 version using the defaults.

I didn't realize that she had some Access databases on her PC that she still
used.
Now she can't.

I've done some reading and have instructions on how to install both versions
on her PC but I'm wondering what the best step is for me to get her PC back
to just Office 97.

Nothing I've read mentions using the XP system restore.

Can I just restore it back to the day before I installed Office2000 and
she'll be all set or is there something additional I need to do?

I also read, and I'm not sure if this is the case, that Access 97 is still
there because 2000 installs in a different location?
So if she opens the Access97 program (and not the database) and then uses
that to search for her database she might be all set?

Any help would be appreciated.

 

[Bill Mosca, MS Access MVP]

If you installed 2000 after 97 there should be no problem except you can no
longer just double-click a MDB file to open it. Your Operating system will
use the last version you opened to open the file. So if she opened a 97 and
then a 2000 it will try to open it with 97.

As you asked in your last question, Yes, opening Access first and selecting
the db file will work fine unless she opened Acc97 and tries to open a 2000
file.

I have all three versions installed on my PC with no problems. I just
installed them in order, oldest first.

If you want to remove 2000, you will have to uninstall it. a restore is not
going to do it. In fact, if you try a restore before uninstalling, you will
run into errors due to missing reg keys.

 

[Larry Daugherty]

There are things you can do in your file associations so that right
clicking an MDB would offer you a choice of which version to use to
open it.

Even better, there is a utility, ACCVER, from David Aylott that will
autmagically open the correct version. It's shareware and costs $15
for a license. I have several versions of Access on my development
system and it sure saves time and hassles.

HTH