Solved

Saving an .MDB as a .accdb

Posted on 2013-11-05
3
478 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
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 - Access MVP) earned 100 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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now