Access 2002 upgrade question

[Maxx Excaliber]

Does anyone know if I can use the Access 2002 Upgrade CD to upgrade the
Access component of Office 97? One of our departments is having an outside
consultant do some work for them, but the consultant uses Access 2002, and
we have Access 97. I know that the data format is different between Access
97 and Access 2000. I'm going to go out on a limb and guess that the data
format of Access 2000 is also incompatible with Access 97.

If someone here knows the answer, I'd appreciate a response. Please keep
in mind, if you choose to reply via email, that the email address in the
headers goes to a bit-bucket. Please use the email address in the sig if
you want to respond via email. Thanks.

 

[Douglas J. Steele]

Yes, Access 2000 uses a different, incompatible format than Access 97.

Actually, by default, Access 2002 and Access 2003 use the same format as
Access 2000, although each has its own format as well. All three versions,
however, are capable of saving a database in Access 97 format (through Tools
| Database Utilities | Convert Database). There can be some issues with the
conversion if you're using functionality that exists in the newer versions
that didn't exist in Access 97, but other than that, you shouldn't have any
problems. (I personally find the biggest issue is that I tend to use the new
VBA functions such as Replace, Split and so on. Consequently, I have a
module I add to my Access 97 databases that provide the same functionality
as those functions that are built into the later versions)

Since the consultant is doing the work for you, he should be obligated to
provide it in whatever format you choose.

In answer to your original question, though, yes, you should be able to use
the Upgrade CD to replace Access 97 from your Office 97 with Access 2002.
(Note that since it's an upgrade CD, it's not legal for you to have both
versions on your PC, even though that's certainly possible)

 

[Maxx Excaliber]

Yes, Access 2000 uses a different, incompatible format than Access 97.

Actually, by default, Access 2002 and Access 2003 use the same format as
Access 2000, although each has its own format as well. All three versions,
however, are capable of saving a database in Access 97 format (through
Tools
| Database Utilities | Convert Database). There can be some issues with
| the
conversion if you're using functionality that exists in the newer versions
that didn't exist in Access 97... [snip]
In answer to your original question, though, yes, you should be able to
use the Upgrade CD to replace Access 97 from your Office 97 with Access
2002. (Note that since it's an upgrade CD, it's not legal for you to have
both versions on your PC, even though that's certainly possible)

Thanks, Doug. I shoulda "Googled" first as I found the answer through a
Google Groups search.

Since we have both Office 2000 and Office 97, we have a mix of those two
and have found the problem you describe of "enhanced features" in the
newer version not working in the exported database. For this reason, I
think it might be best to go ahead and upgrade the three client machines.

Thanks again!

 

[paul bickert]

Yes, Access 2000 uses a different, incompatible format than Access 97.

Actually, by default, Access 2002 and Access 2003 use the same format as
Access 2000, although each has its own format as well. All three versions,
however, are capable of saving a database in Access 97 format (through Tools
| Database Utilities | Convert Database). There can be some issues with the
conversion if you're using functionality that exists in the newer versions
that didn't exist in Access 97, but other than that, you shouldn't have any
problems. (I personally find the biggest issue is that I tend to use the new
VBA functions such as Replace, Split and so on. Consequently, I have a
module I add to my Access 97 databases that provide the same functionality
as those functions that are built into the later versions)

Since the consultant is doing the work for you, he should be obligated to
provide it in whatever format you choose.

In answer to your original question, though, yes, you should be able to use
the Upgrade CD to replace Access 97 from your Office 97 with Access 2002.
(Note that since it's an upgrade CD, it's not legal for you to have both
versions on your PC, even though that's certainly possible)