[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 814
  • Last Modified:

Differences between access 97, 2000, and 2002, including backward/forward compatibility

Can you please tell me what the differences are between 97, 2000 and 2002?(ms access).  Also, as I recall either 2000 or 2002 is not backward compatible with 1997??  Thank you!
0
pmilllok
Asked:
pmilllok
  • 3
  • 3
  • 2
  • +3
2 Solutions
 
tbsgadiCommented:
Check out
http://office.microsoft.com/en-us/assistance/HP052817081033.aspx
About using an Access file with multiple versions of Access

Good Luck!

Gary
0
 
Arthur_WoodCommented:
1)VBA code in Access 97 is based on Visual Basic 5, while VBA in Access 2000 and newer is based on Visual Basic 6

2) The internal database structure in Access 97 is different from that in Access 2000 and newer - this is the single biggest difference, and it is this that makes it difficult to migrate backwards from Access 2000 to Access 97 (it can be done, using the Access 2000+ command to Convert Database (under Tools/Database Utilities)).

3) Access 2000 and newer uses ActiveX Data Objects (ADO) as the primary Data Access technology, while Access 97 used Data Access Objects (DAO).  This may have direct impact on the use of Data Bound controls, between versions.

4) There are some subtle (but possibly important) differences in the specifis of VBA code in the three newer version (Access 2000, Access 2002/XP, and Access 2003) that can cause problems in trying to migrate bewteen these three releases.  Access 2003 supports the potential for interacting with the .NET Framework, directly.

AW
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Hi pmilllok,

From what I've surveyed from most developers...

Changes from 97 to 2k are Data Access Pages, greater acceptance of ADO-ADOX, Groups, and a few other bells and whistles.
Changes from 2k to 2003 are all very minor (Boolean values allow Nulls, Mouse Wheel events)

Hope this helps.
-Jim
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Beginning in 97, all versions are forward and backward compatible.
0
 
Arthur_WoodCommented:
jimhorn, that is not 100% correct.  If you have added VBA code to an Access 2000 or newer app, and made use of the NEW code features, then you cannot easily go back to Access 97.  For instance, Access 2000 +  allows for a .AddItem method on a ComboBox, which allows your code to add items one at a time, in code, to the combobox dropdown list.  This method is NOT supported in Access 97 , and so the compiler will choke, if and when you attempt to revert to Access 97.

Also, once an Access 97 strutured MDB has been opened and CONVERTED to Access 2000 format, it can no longer be directly opened in Access 97 (you will get an "Unrecognized Database Format" error) - you would need to convert the Access 2000 MDB to the earlier version (Access 97), before it could be opened in Access 97.

AW
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
I stand corrected.  Other than any custom programming in features that are not present in older versions, you can use the Tools:Database Utilities:Convert... functionality to convert an mdb up or down.

Also, when I made my first post, I didn't see your earlier post.  Sorry about the duplication.
0
 
Jeffrey CoachmanCommented:
Just my 2 cents...

Most people should set up all users to the SAME version of Access.

Althought they are "usually" compatible 1 version up or down.

For example if you create a database in 2002  and by default it saves it as version 2000, for some reason you cannot view the database properties if you open it in 2000.
0
 
ArjiCommented:
I have found that Access 2k3 is quite quircky. I have had several wierd things happen that seemed to 'fix' themselves after a restart of Access.  Also several methods do not work the same in Access 2k3 as they do Access97.  Personally, if things are working fine in Access97 and you don't plan on moving to SQL server....don't fix it if it ain't broke. :-)
0
 
Arthur_WoodCommented:
boag2000 >> while I agree in principle, in the REAL world,that is not always possible in practice.  I once worked on an application for the US Air Force in the Pentagon in Washington DC, during a period when the Pentagon was in a state of flux between Access 97 and Access 2000 - not ALL workstations had been 'certified' by the Air Force IT powers that be to have Office 2000 installed - they are a bit paranoid about such things, but that is a whole different conversation, and as a contractor, my duty was to act like the Cavalry of the Light Brigade ("Their's was not to wonder why, their's was but to do or die..."). When it comes to the authorities of my customer, when they say jump, I have to ask "How high?" on the way up.  So some users were configured with Office 2000 and other had Office 97, but the application was deemd to be "Mission Critical" to the Office where I was working, so I created both an Access 2000 Front-end AND and Access 97 Front-end , with a common Access 97 Back-end - worked like a charm, for the 2 months that it took to get all of the Access 97 workstations certified to upgrade to Office 2000, at which point the Access 97 Front-end was 'retired' so to speak.

AW
0
 
Jeffrey CoachmanCommented:
OOPS!

Thanks Arthur Wood,
 
Sorry, perhaps I should have said: "TRY" to keep the same version, if you can.
:)

I just don't know if I would stretch it to 3 versions, as the original post implied.

Thanks for the info.



0
 
pmilllokAuthor Commented:
Arthur Wood - thanks for the detailed response.  After doing research from other sources, i found your response the most thorough and accurate.  I'm not sure why you have "assisted" answer.  I apologize if I slighted you.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now