?
Solved

Access 2003, 2007, 2010, compatibility

Posted on 2011-02-19
11
Medium Priority
?
421 Views
Last Modified: 2012-08-14
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.

0
Comment
Question by:Alaska Cowboy
[X]
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
  • 7
  • 2
  • 2
11 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 34934168
"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
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 34934172
mx - ok, great, thanks.

I've downloaded Access 2010 trial version and will give it a whirl.
0
 
LVL 6

Expert Comment

by:Gugro
ID: 34934179
Yes it should run on Access 2010 too. There were no big changes to 2007, more a sort of "service release" ;-))
0
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 
LVL 75
ID: 34934185
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
 
LVL 75
ID: 34934189
I have several more links if you want them ..?

mx
0
 
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: 34934193
0
 
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: 34934197
OH ... better look this over for sure (many apply to A2010):

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

mx
0
 
LVL 75
ID: 34934201
"more a sort of "service release" ;-))"
Ummm ... a bit more than that I would say ... :-)

mx
0
 
LVL 6

Expert Comment

by:Gugro
ID: 34934253
> "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
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 34934258
gugro - thanks

mx - thanks for the the links and tips, reviewing now.
0
 
LVL 75
ID: 34934270
"Still the VBA Editor from last century ;-))"
And it's as good as ever :-)

mx
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

718 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