?
Solved

Saving an .MDB as a .accdb

Posted on 2013-11-05
3
Medium Priority
?
528 Views
Last Modified: 2013-11-05
I am working with some legacy MDB's in Access 2010 that must be upgraded to .accdb's.  I thought that 'Save Database As' option on the file menu would allow me to do that.  When I do the save as I overtype 'DBName.MDB' with DBName.accdb but the type on the file type line cannot be altered.

How do I save a .MDB as an .accdb?  The MDB has to be in the newer format to link in some other database tables that are in the .accdb format.
0
Comment
Question by:mlcktmguy
[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
3 Comments
 
LVL 10

Expert Comment

by:etech0
ID: 39625894
This might work: create a new, blank database (which will be .accdb). Then import all the objects from your old mdb to your new database (accdb)
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 400 total points
ID: 39625896
Should be this:

1
 2
0
 
LVL 1

Author Closing Comment

by:mlcktmguy
ID: 39626133
That's what I was looking for, thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

764 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