Solved

Maintain an Access 2003 (.mdb) application with Access 2010

Posted on 2013-05-19
4
611 Views
Last Modified: 2013-05-21
Hi,

I have got a large application developed in Access 2003 (mdb) and is distributed as a mde. Most of my clients are still using 2003. I am full aware that the mde can't be created by 2010, I have to do that on a PC with 2003.

Still I wonder, are there any large problems to maintain the mdb in Access 2010? I will not use the new features.

I have started to find my way around in the 2010 user interface, but still the developement is slower than in the 2003 but will be faster in the future.

Thanks in advance.

BR

B Anders
0
Comment
Question by:BACapta
4 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39178665
My rule is to develop in the appropriate version to avoid any potential of conflict.  I have 2003 and 2007 running on one PC and 2010 running on my Windows 7 laptop, with 2007 running in XP virtual mode.
0
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 125 total points
ID: 39178697
In my experience if the MDB was first create with Access 2003 or earlier and very converted you can maintain it will 2007/2010 without issues. I have found that the new feature are disabled in 2007/2010 when the database was create with a prior version. If the database was created in the new  ACE (*.accdb) format and downgrade then I have issues with feature that are not backwardly compatible.

IMHO, I  believe that your  development and testing (most people neglect this)  in the version that will create the MDE. I have found that to be the best in the overall stability of the application.  I use a VM to run each version of Office.

FWIW: For your clients/users that still have Office 2003, they could use the free Access 2010 runtime.  

.
0
 
LVL 10

Assisted Solution

by:LukeChung-FMS
LukeChung-FMS earned 125 total points
ID: 39179407
For some of our Microsoft Access addins, http://www.fmsinc.com/MicrosoftAccess/add-ins/products.htm, we maintain the same code base across multiple Access versions. That can include the latest version in an accdb format. We have a detailed process when making builds to make sure each release is created properly including the need to convert to Access 2003 mdb formats. The programs may also have code, data, and objects that are specific to version. It's complicated because we are targeting multiple platforms but that's what we need.
0
 

Author Closing Comment

by:BACapta
ID: 39184524
For the moment, this is what I wanted to know. Many thanks! B Anders
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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 …

708 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now