convert access adp to accdb or mdb format

Do you have such access data projects that are now no longer supported in 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 regarding the conversion of former Access Database project .ADP 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 format is no longer supported in MS Access database version 2010/2013/2016. Adp file that are used with Ms Access can ofcourse 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 your old .adp file in your newer version Access Database like 2010/2013/2016, 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?

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 An 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. For the conversion of An ADP File To MDB just follow down these steps:

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…!

 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.
  • 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 An 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 Filetab, 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.

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 Asdialog 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.

Also Read:

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

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.

How To Convert Access Data Projects (.Adp file) To Microsoft Access Database (.Accdb Or .Mdb) File Format