If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2002 upgrade question
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. -- Maxx Excaliber Just a user, NOT an Admin/Deputy |
#2
|
|||
|
|||
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) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Maxx Excaliber" wrote in message news 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. -- Maxx Excaliber Just a user, NOT an Admin/Deputy |
#3
|
|||
|
|||
On Thu, 26 Aug 2004 10:55:00 -0400, Douglas J. Steele wrote:
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! -- Maxx Excaliber Just a user, NOT an Admin/Deputy |
#4
|
|||
|
|||
"Douglas J. Steele" wrote in message ... 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) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Maxx Excaliber" wrote in message news 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. -- Maxx Excaliber Just a user, NOT an Admin/Deputy |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2002 upgrade question | Maxx Excaliber | General Discussion | 3 | August 28th, 2004 02:31 PM |
Access 2002 install blunder | Chuck McKinnon | General Discussion | 2 | August 26th, 2004 11:05 PM |
Question on lauching access and syntax error during batch file | Adam Raff | General Discussion | 2 | August 12th, 2004 04:20 AM |
Acess 2002 Service Pack 3 | J. Haney | General Discussion | 2 | July 29th, 2004 12:59 AM |
Access 2000, 2002 and BTRIEVE 6.14 problems with memo fields | SSGTech Tim | General Discussion | 0 | July 1st, 2004 05:42 AM |