Access on Office 7.0 using XP

[Ken]

I recently purchased a new pc with XP. I installed my
Office 7.0 successfully but I can't open databases
previously created on Windows 98. Are there patches or
upgrades I need to install?

 

[Phil Carrero]

Ken:

I wonder why they do this...
In previous versions you could install different versions separately
and run them if you called the right version to open the right app.
But Access XP won't have it with Access 7.0 You'll have to either
convert to Version 2K or open an empty db, import the old app and resolve
the compilation issues. I just couldn't have those two running in the same
machine.
Even uninstalling XP... I had to format the HD and re-install the
lot. I admit, though, that converting is the easiest of the two if you want
to keep XP

Phil

I recently purchased a new pc with XP. I installed my
Office 7.0 successfully but I can't open databases
previously created on Windows 98. Are there patches or
upgrades I need to install?

 

[Larry Linson]

Although I get the Convert or Open dialog box a couple of times, I just
opened an Access 97 database in Access 2002 by choosing "Open". No version
has allowed you to modify a previous version's file format without
converting.

Using Access 2002, should you want to modify the Access 97 database, you can
convert it, make the mods (avoiding any Access 2000 or later-specific
features), then save it in Access 97 format via the Tools | Database
Utilities | Convert | Save as Access 97 steps on the main menu.

I have Access 97, Access 2002, and Beta 2 of Access 2003 all installed, in
different folders, on this machine, and they are more-or-less happily
coexisting.

Larry Linson
Microsoft Access MVP

 

[Phil Carrero]

My, you're right, it works! But debugging is time consuming and
saving new design is a bit awkward from 2002.
I assume you can also run the old mdb on Access '97, for the sake of
speed, while you debug the new converted mdb on Access 2002... in the same
machine.
I have a friend like you. She can do anything!
My only hope against ignorance is that I can still learn...

Phil

Although I get the Convert or Open dialog box a couple of times, I just
opened an Access 97 database in Access 2002 by choosing "Open". No version
has allowed you to modify a previous version's file format without
converting.

Using Access 2002, should you want to modify the Access 97 database, you can
convert it, make the mods (avoiding any Access 2000 or later-specific
features), then save it in Access 97 format via the Tools | Database
Utilities | Convert | Save as Access 97 steps on the main menu.

I have Access 97, Access 2002, and Beta 2 of Access 2003 all installed, in
different folders, on this machine, and they are more-or-less happily
coexisting.

Larry Linson
Microsoft Access MVP

 

[Larry Linson]

Like the Eagles' song, it's probably just that "I've spent more time with my
back to the wall..". I've been using Access and developing Access
applications just about every day since January 1993.

The reason I have Access 97 on my machine is that is what I use to maintain
clients' Access 97 applications.

My comments on using Access 2002 for that purpose were for someone who no
longer has Access 97 installed, but needs to work on someone else's Access
97 database.

In fact on another machine, I still have Access 2.0 installed, and Access
2000, just in case, though I haven't needed either very much in the last
couple of years.

Larry Linson
Microsoft Access MVP