Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Functional differences between MS Access 2002 and 2003

Posted on 2008-06-17
Medium Priority
Last Modified: 2012-05-05
I'm looking for a list of functional differences between A2002 and A2003.  I've learned a couple of things:

MDE's compiled in 2003 won't work in 2003.
They both use the 2000 file format.

Where might there be a list of the other differences, so I can avoid using those in 2003?    Or, at least, where are the areas of difference?
Question by:codequest
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 21806571
Not that much.  A2003 add Window Themed Controls (very cool) - but that will be ignored on an A2002 (aka XP) machine, so not a problem.

Also, I think (but not sure)

"MDE's compiled in 2003 won't work in 2003."

Huh ?
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 700 total points
ID: 21806605
check for the References from vba windows Tools>references..
they have different versions
LVL 61

Accepted Solution

mbizup earned 800 total points
ID: 21806631
This is not a side-by-side comparison, but it lists features that were "new" with A2K3:
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

ID: 21806670
Thanks for inputs.

Uh duh....meant to write

"MDE's compiled in 2003 will not work in 2002....."

Is that true?
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 700 total points
ID: 21806727
"MDE's compiled in 2003 will not work in 2002....."

Is that true? depends on the references used.

if there were references used in the mde that are only available in 2003 and not in 2002 --- 100%  the mde will NOT work in 2002

Author Comment

ID: 21806854
Ok, thanks for inputs, I'll be back soon

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question