Solved

Updating Access 2003 to 2010

Posted on 2014-10-24
4
224 Views
Last Modified: 2014-11-07
We have been using access 2003  since it first  came out and are now planning to update to 2010 or 2013.
I purchases 2010 about 2 years ago just to test our program and sure there were no issues running in
2010.  I had no major issues and it seems OK.  Question 1: When using 2010 our front end is still an mdb
as is the back end.  What if any features do I loose if I maintain the mdb format. Question 2: If I convert the
files to the new format  accbe   I found that I have some issues with  referances and have to reinstall them.
I am currently working my why through this problem. Does anyone have some insite into this problem?

Bill
0
Comment
Question by:Billxxxx
[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
  • 2
4 Comments
 
LVL 37

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40402459
The list of what you don't have is pretty long.  You can find "differences" posted in the MS literature but you have to go back to A2007 and look at each version in turn.  

As long as the current version of Access still supports the mdb version you are using, there is no compelling reason to change the format unless you want to take advantage of some new feature.  As time goes on though, features are deprecated and will no longer work so you have to keep on top of that to prevent getting blindsided.  Two big loses with A2013 were pivot tables/charts and .dbf files so if you rely on either of those, it is time to make other plans.  In theory, you can automate Excel to get pivot tables/charts but there is no replacement for the drivers to read .dbf files.  The big loss moving to A2007 (the original ACE version) was the loss of ULS.  So if you are relying on User Level Security, there is no substitute.  You will have to write your own code or do without.
0
 
LVL 10

Expert Comment

by:Luke Chung
ID: 40404020
Unless you want to add the new field types for multivalue and attachments, the new features are available for mdb files.

Here's my whitepaper about the many great features one can add to Access 2003 apps for "free" when going to 2007 or later: http://fmsinc.com/MicrosoftAccess/2007/Top-Features.html

Hope this helps.
0
 
LVL 37

Assisted Solution

by:PatHartman
PatHartman earned 500 total points
ID: 40406427
Yes, there's a difference between the structural features and the interface features.  Structural features require switching the database format to .accdb.  Interface features work regardless of the actual database file format.  However, if you have users who are still using A2003, they could have a very different user experience with the .mdb than users using A2010.  You also could run into rendering issues as Access tries to backward convert themes from A2010 to the hard-coded formats of A2003.
0
 

Author Closing Comment

by:Billxxxx
ID: 40429120
All of the responses were very helpful.  I did not really have a single problem
to solve I was looking just for general information that help me in the transition.
I have already imported all the data into 2010 format and did it in numerous ways.
I did the Back end and front end into blank data bases, I used the save as method.
I never encounter problems that couldn't be resolved easily. However there is one
problem that I need an answer to about references. I guess I will post that as a new
question.

Thanks to everyone who helped.
0

Featured Post

Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This article summaries thoughts and ideas from two years of sustained use. It provides good reasoning to make the jump to Windows 10.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

734 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