Access 97 and Office 2003 on the same PC?

[Scott Friedman]

My client here runs Outlook 2003 and needs to use Access 97 for an
antiquated database that won't work in 2003. He removed Access 2003 and
installed Office 97 (just Access and Data Access components) but when he
tries to open the DB in Access 97, it just crashes right away.

Is this possible? He's found a few tech notes on the support site about
Office 2000 and 97, and followed those (renaming a font before installing,
then renaming it back) but it didn't work.

Any thoughts?
Scott

 

[Guest]

Access is not like excel or word, he needs to convert the databases to the
correct application version. I mean: when he opens a 97DB in Access 2003, the
application asks if you want to convert the file to the newer version; or
when he had the 2003DB, he should convert it into the 97 version (Tools -
Database Utilities - Convert Database - To Access 97 file format).

 

[Scott Friedman]

He is trying to open the Access 97 DB using Access 97, but it crashes when
he tries to open it. The person who created the Db says it won't work in
2003, just Access 97.

 

[Dirk Goldgar]

He is trying to open the Access 97 DB using Access 97, but it crashes
when he tries to open it. The person who created the Db says it
won't work in 2003, just Access 97.

I suppose that's conceivable, but it's not a normal circumstance. With
the information currently available, I think it's more likely that the
installation of Access 97 is messed up. I think I would first
completely remove Access 97 from the PC, then repair the installation of
Office 2003 *with* Access 2003, and make sure that Access 2003 is
working properly. Then I'd see if it's really true that the database
won't work under Access 97 -- did its creator say why? Maybe it's
modifying objects on the fly.

If it proves to be true that the database won't work except with Access
97, I would then install Access 97, *making sure to install it to a
different, non-default directory*. I would then start Access 97 from
the start menu (not by double-clicking on the database file) and open
the database to see if it works.

I have Access 97, Access 2000, and Access 2002 all installed on my PC,
and they work fine except that I had to take steps to keep Access 97
from registering itself as the default handler for .mdb files every time
I run it.

 

[Tony Toews]

My client here runs Outlook 2003 and needs to use Access 97 for an
antiquated database that won't work in 2003. He removed Access 2003 and
installed Office 97 (just Access and Data Access components) but when he
tries to open the DB in Access 97, it just crashes right away.

What's the error message?

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

 

[musheer.alam]

HI,

Please help me to run access 97 & 2003 on window 7, i was running both version successfully on XP, but problem started since I Installed window 7 either i can use 97 or 2003 at a time.

Regards,

Musheer