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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
"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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
I have several more links if you want them ..?

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

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

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"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 MVP, Access and Data Platform)Commented:
"Still the VBA Editor from last century ;-))"
And it's as good as ever :-)

mx
0
All Courses

From novice to tech pro — start learning today.