Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Starting new database in access 2003 wondering if I should use access 2010

Posted on 2011-02-22
Medium Priority
Last Modified: 2012-05-11
Hello Experts,

I'm going to be starting a new database and I'm really familiar with Access 2003, and was curious how much different Access 2010 is and why I would need it when my applications work just fine being build using access 2003.

Is there a compatibility issue I need to be concerned with, all my .mdbs were built using Access 2003 and they work just fine in windows 7.

Everything I need is in Access 2003, so I'm just curious why I would want to use access 2010.

Is there a reason that any of you can see as to why I should buy Access 2010 and develop my new applications using it, knowing they work just fine in access 2003?


Question by:patentinv
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
  • 4
  • 3
  • 2
  • +1
LVL 75

Accepted Solution

DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 total points
ID: 34958523
"Is there a reason that any of you can see as to why I should buy Access 2010 and develop my new applications using it, knowing they work just fine in access 2003?'

Based on your scenario ... I'm hard pressed to come up with a compelling reason to move to A2010 now.

But ... FWIW ... here are some resources discussing the differences, nonetheless of which is the Ribbon Menu system, which in itself is a pretty big learning curve.

Access 2010 Development

Access 2010 Migration Guide:

Access 2010 specifications

New Features in Access 2010

Bug list for A2010 (and A2007) - with links to other lists as well
LVL 19

Assisted Solution

MINDSUPERB earned 1000 total points
ID: 34958540
My point of view is: It would be always a good practice to go with the new technology.

It would be at your advantage if you learn something new through familiarization of the new features and functionalities of the new version.

Access 2003 runs smoothly in 2010 version at this time but it is not an assurance that it would be when another new Access version will be released in the future.


Author Comment

ID: 34958607
Hello Experts,

I think Eds point stating access 2003 might not run in a new released version of access, but I turn all me .mdb into run time versions, which is more depend upon the OS like when windows 7 came out they released a new run time version to support win 7.

So it really doesn't matter if a new released version of access supports 2003 or not to me. All my programs get turned into .exe and use the run time.

It doesn't matter if the installer has access installed or not, these apps will still run.

So with all this said I've pretty much convinced my self even when a new version comes out I don't think it would matter.

Maybe I'll stick to old faithfull access 2003 and not go through the learning curve of the ribbon, secondly what if a new version comes out and it replaces the ribbon.

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.

LVL 19

Expert Comment

ID: 34958636
Every developer has his/her own approach on the what and the how in designing the application based on existing factors.

You have your point and you can stick with it.


Author Comment

ID: 34958716
I've been thinking this over for quite some time periodically, and finally had to at least ask if there was a good reason to change to 2010.

I'm simple,if it works and there isn't a overwhelming reason to change, why bother.

I really appreciate your in put.

Hello Database MX!!



Author Closing Comment

ID: 34958730
Thanks again!!!
LVL 75
ID: 34958736
Always a pleasure ...

Author Comment

ID: 34958749
We'll I just heard prerecorded "dust in the wind" which means here in Neveda radio stations its 12:00 time for bed.

Thanks again!!
LVL 58
ID: 34969854
<<Is there a reason that any of you can see as to why I should buy Access 2010 and develop my new applications using it, knowing they work just fine in access 2003?>>

  One major consideration would be if you plan to distribute your apps.  If so, the runtime for users without Access is free to distribute with Access 2007 and up.   For prior versions, you need to buy a license.

  The other point is that at this point, A2003 is now eight years old.  That's not to say it's not useable, but at some point you'll start having issues with newer OS's.

  Remember Access doesn't end up as a true executeable, so it's very sensitive to the environment.

LVL 75
ID: 34972420
"That's not to say it's not useable"
That's for sure. Probably the most 'in use' version around.


Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

618 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