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

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?

Thanks,
patentinv



patentinvAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
"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
http://msdn.microsoft.com/en-us/office/ff621506.aspx

Access 2010 Migration Guide:
http://blogs.msdn.com/b/access/archive/2010/09/07/download-the-free-access-2010-migration-guide.aspx

Access 2010 specifications
http://office.microsoft.com/en-us/access-help/access-2010-specifications-HA010341462.aspx

New Features in Access 2010
http://msdn.microsoft.com/en-us/office/ee513173.aspx

Bug list for A2010 (and A2007) - with links to other lists as well
http://allenbrowne.com/Access2007.html#Bugs
0
 
MINDSUPERBConnect With a Mentor Commented:
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.

Sincerely,
Ed
0
 
patentinvAuthor Commented:
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.

Thanks,
patentinv
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
MINDSUPERBCommented:
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.

Sincerely,
Ed
0
 
patentinvAuthor Commented:
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!!

Thanks,
patentinv

0
 
patentinvAuthor Commented:
Thanks again!!!
patentinv
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Always a pleasure ...
0
 
patentinvAuthor Commented:
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!!
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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.

FWIW,
JimD.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"That's not to say it's not useable"
That's for sure. Probably the most 'in use' version around.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.