Convert Access to 2010 format

rtod2 used Ask the Experts™
When forming macros, I sometimes get a message that says I need to convert the DB to the newer version before I can use a particular macro.  How do I do this?

Explicit steps are greatly appreciated.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

What version of Access are you using currently?
If you are using A2003 or earlier then you will find a completely different macro environment in A2010.
There are many new commands but also more restrictions on what you can do.  
You may well have found that most people here have little knowledge of macros in A2003 and earlier.
It will be apparent that the level of knowledge is even less for the new set up (I include myself in this).

There is a built -in database conversion tool , but it has become apparent that the most reliable way to convert an mdb to an accdb is to create a new empty accdb and import all the objects from the existing mdb into it.  Use the ExternalData section of the ribbon.

Keep your mdb safe as a backup.
I recently asked a question on the topic of upgrading a database, my expert was very helpful:

Have a look for this ID: 26981743.


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial