Updating Access 2003 to 2010

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
BillxxxxAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Luke ChungPresidentCommented:
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
PatHartmanCommented:
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
BillxxxxAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.