How To Convert ADP File To ACCDB/MDB File Format

Do you have older Access Data Projects(.adp) file which are no more supporting in your currently running Access database versions like 2010/2013/2016?  Looking for the solution to resolve this unsupported file format issue of Access Database?

Well in that case you just need to go through this post thoroughly. As, this contains all the fixes for converting adp file to.mdb or.accdb format.

Microsoft Access Database (Mdb/accdb) Vs Access Data Project (Adp)

Well both Microsoft Access Database (mdb/accdb) and Access Database Project (adp) can be used to develop database management applications. Although their business objectives is similar but they differ in their specification.

 The main difference between these two is that Microsoft Access Database contain all codes, data, queries etc. in one neat little container. Whereas, ADP separates the data from the application using tables and queries residing on back end database like SQL server. It holds access project information and communicates directly with Microsoft SQL Server database.

Why Access Data Projects Are No Longer Supported In Version Of Access 2016/2013/2010?

The fact is .adp file or Access Data Projects Are No Longer Supported in MS Access database version 2010/2013/2016. Adp file that are used with MS Access can of course opened with programs too but only if you are running an older version of access database like 2002/2002/2003/2007.  They also don’t work with SQL Server 2012 or newer.

So, when you try to open .adp file in Access 2016/2013/2010 database, it starts showing error:

“Access Data Projects Are No Longer Supported”

Access Data Projects Are No Longer Supported In This Version Of Access

Before approaching towards the resolution section just take a look over the scenario that is faced by one of the Access Database user just like you.

Practical scenario:

Hello,

Can someone tell me the best steps to fix this?  I have an old access data project that no longer works on newer versions of Access. Now whenever I click on the file I get this error, “Access Data Projects are no longer supported in this version of Access.”.  I have already exported the actual database tables to my sql server which is running sql server 2008 R2.  But the user interface is still at .adp file which is now linked to my sql server.  It would be great if I could just turn it all into web forms or something but I don’t know how I can export all the queries, forms and reports that are in the project.   I am able to open the .adp file on a virtual machine where I am running an older version of Access  in a Windows 7 environment. 

thanks

Source:

https://www.experts-exchange.com/questions/28914221/Access-error-Access-Data-Projects-are-no-long-supported-in-this-version-of-Access.html

How To Convert .adp To .mdb/.accdb file format?

How To Convert .adp To .mdb/.accdb file format

Access 2010 and Access 2007 by default creates databases in .accdb file format. This format supports new features like data macros, multivalued fields and publishing to Access services.  But the relaxing point is that you can convert databases that were created previously in MS Office Access 2003, Access 2002, Access 2000, or Access 97 i.e .adp to the .accdb file format.

You may also like:

How To Convert MDB Access Database File Format To ACCDB

However the database in .accdb file format can’t be opened or linked by using versions of access earlier than Access 2007. Along with that the .accdb file format doesn’t support replication or user-level security. Whenever you need to share your database with people who are using Access 2003 or earlier or when you need to use replication or user-level security then you should use the Access .mdb file format.

How To Convert ADP File To MDB?

Well adp and mdb file are two database file format created by Microsoft Access. ADP files are SQL database files whereas mdb files contain Access project information about the ADP files which are stored in the Access project. If you are having an ADP file and it denies to get opened in Access database version 2016/2013/2010 then also you have the option to convert it MDB file format. To convert ADP file To MDB just follow down these steps:

 Steps To Convert ADP File To MDB :

  • Firstly you need to Open your Microsoft Access.
  • After then tap to the “File” option menu bar and click to “Open,” option.
  • Now hit the ADP file that you need to convert to MDB format.
  • Then click to the “File,” option and then click “Share”. After then hit the “Save Database As” option.

Convert ADP File To MDB

  • Choose the “Access Database” file type, and then assign the name for your newly created MDB file.
  • Now tap to the save option and your MDB file is created and saved to your PC.

How To Convert  ADP File To ACCDB Format?

Convert An Access 2000 Or Access 2002 – 2003 Database To The .Accdb Format

In order to convert an Access 2000 or Access 2002 – 2003 database (.adp) to the .accdb file format, you firstly need to open the database using Access 2007 or Access 2010, and then save it in the .accdb file format.

  1. From the File tab, click to the Open option.
  2. Now in the Open dialog box, choose and open the Access 2000 or Access 2002 – 2003 database (.adp) file that you required to convert.

Note: 

If database Enhancement dialog box appears, then it means the database is using file format earlier than Access 2000.

  1. Again go to the File tab, tap to Save & Publish option and then, under Database File Types hit to the Access Database (*.accdb) file format.
  2. At last hit the Save As button.

Convert  ADP File To ACCDB Format

While making a click over Save As option if any databases objects are already open then Access asks you to close them prior to creating the copy.

So, tap to the Yes option so that access will close all the opened objects. Or else you can tap to the No option to cancel down the entire process.

  1. In the Save As dialog box, assign any file name in the File Name and then tap to the Save.

Access makes a copy of the database and then opens it after automatically closing down the original database.

Convert An Access 97 Database To The .accdb Format

Here is the complete step on how to convert an Access 97 database (.adp) to the new file format (.accdb).

  1. In Access 2010, on the File tab, click Open.
  2. From the Open dialog box, select and open the Access 97 (.mdb) database that you want to convert.
  3. Now in the opened Database Enhancement dialog box, click to the Yes option. 

Access makes a copy of the database and then opens it after automatically closing down the original database.

Note: 

Remember you can’t use the resulting .accdb file in access database version 2007/2003/2002/2000.

Use Access 2007 To Open A Database That Was Created Or Modified In Access 2010

As Access 2010 and 2007 shares the same file format, you can use Access 2007 to open up the database that was created in Access 2010 without using the Save As command. Moreover depending on the features, following issues comes across if anyone tries to use database in access 2007.

  • Unable to modify the object that uses the new feature.
  • Can’t open the object that uses the new feature.
  • Denies opening of the database in Access 2007 at all.

Bottom Line:

After reading the complete post now you must have got how to fix “Access Data Projects Are No Longer Supported version” issue. So, try all the above mentioned manual steps carefully and do share your experience after apply such in our comment section.

Also Read: 

How To Fix MS Access Run-time 3146 ODBC Call Failed Error?

How To Fix MS Access Error 3259- “Invalid Field Data Type” And It’s Related Issues…!

How To Fix Access “Can’t Find Project Or Library” Error

tip Still having issues? Fix them with this Access repair tool:

This software repairs & restores all ACCDB/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.

  1. Download Stellar Repair for Access rated Great on Cnet (download starts on this page).
  2. Click Browse and Search option to locate corrupt Access database.
  3. Click Repair button to repair & preview the database objects.

Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access & sharing tech blogs.