Access 2003, 2007, 2010, compatibility

Two years ago I stopped developing in Access 2003, about when Access-2007 was introduced.

My 2003 application actually runs ok inside Access 2007. Now I see Access 2010 is out.

Should I expect my 2003 application to run inside 2010 ?

I'm debating about purchasing 2003 /2007 / 2010 to pick up on maintaining a 2003 application, plus some new development.

LVL 1
Alaska CowboyAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
"Should I expect my 2003 application to run inside 2010 ?"
For the most part ... yes.  You will of course have to get used to the Ribbon menu system.

I would suggest looking over these KB's ...

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

Access 2010 Resources:
http://technet.microsoft.com/en-us/office/gg406142.aspx

Access 2010 Object Model Changes Since Earlier Versions
http://msdn.microsoft.com/en-us/library/ee836189%28office.14%29.aspx

mx
0
 
Alaska CowboyAuthor Commented:
mx - ok, great, thanks.

I've downloaded Access 2010 trial version and will give it a whirl.
0
 
GugroCommented:
Yes it should run on Access 2010 too. There were no big changes to 2007, more a sort of "service release" ;-))
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Cool.  Be sure to SKIP A2007.  
Also .. many new features in A2010 in conjunction with Sharepoint 2010 for web stuff.
Our IT dept started deploying O2010 this week at work ... 1000's of users ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I have several more links if you want them ..?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
OH ... better look this over for sure (many apply to A2010):

http://allenbrowne.com/Access2007.html#Bugs

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"more a sort of "service release" ;-))"
Ummm ... a bit more than that I would say ... :-)

mx
0
 
GugroCommented:
> "more a sort of "service release" ;-))"
> Ummm ... a bit more than that I would say ... :-)

And what ?? Looking at http://msdn.microsoft.com/en-us/library/ff955606.aspx#odc_office14_ta_WhatsNewforOffice2010Developers_Access2010
I only see data macros as a new feature.
But for a developer who has an Access 2003 application which is also tested to run on 2007
there is almost no change...
Still the VBA Editor from last century ;-))

0
 
Alaska CowboyAuthor Commented:
gugro - thanks

mx - thanks for the the links and tips, reviewing now.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"Still the VBA Editor from last century ;-))"
And it's as good as ever :-)

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.