Solved

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

Posted on 2013-05-19
4
622 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
[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
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:Luke Chung
Luke Chung 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

740 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