How to Convert a Database Format .Accdb to .Mdb – Easy and Fast

Do you have a database in .accdb format and need to use it with an application that only supports old formats like .mdb? You can convert it from one format to another so that it is compatible and it will not take you more than five minutes.

.Accdb vs .Mdb

Microsoft Access I use the .Mdb file format, but that changed in the new version of Microsoft Office in 2007. Since then all databases use the .Accdb file format, which is much more stable than its predecessor.

  • The format .Accdb is compatible with .mdb databases, even versions prior to this.
  • Accdb cannot use the .Mdb user level when upgrading the database to the latest version.
  • With the .Accdb format you get a better security encryption, multivalued fields and integration with SharePoint and Outlook.
  • The biggest advantage that the new Access format offers over the older version is the ability to store attachments in the databases.

.Accdb vs .Mdb

Reasons to switch from ACCDB to MDB

One of the main reasons for downgrading an .accdb database to earlier versions is the compatibility. There are older systems that were created to work only with databases in the .mdb format.

The same thing happens if you want to see the data contained in a PC that only has Microsoft Office 2002 – 2003 or an earlier version installed. In either case, you should know that converting the database from one format to another can generate conflicts compatibility with data types.

Convert an .Accdb database to .Mdb

It is a fairly simple procedure and if you do it step by step you will not have problems. It is most recommended that you make a backup in the event of a failure.

  • Launch the Access app
  • Click on the Menu file and select the open option.
  • In file explorer select the database you want to convert to .Mdb format.
  • Once it’s open, click Files again and select the option Save database as.
  • Enter the name of the new database and select a folder to save it.
  • Choose the type of file, according to your requirements.
    • If you want it to be compatible with Access 2000 choose the option Access 2000 Database (* .mdb)
    • If you want it to be compatible with Access 2002 or 2003, then choose the format Access 2002-2003 Database (* .mdb)
  • to finish, press the button Keep.

After performing this action, the database in .accdb format is closed and the new one is opened with the format you selected. Any new modifications you make from now on will only affect the copy in the .mdb format, unless you open the original.

Different Access formats

Avoid risk factors when converting a DB from ACCDB to MDB

The .mdb databases are not supported by several features of the newer versions of Access. In these cases, the database cannot be converted unless make certain changes.

  • Remove multivalued search fields: It is a new field type that allows multiple values, but is not supported in MDB and therefore must be cleared before converting.
  • Clear attached and calculated data types: Like multivalued fields they are not supported and must be deleted or modified to another data type to do the conversion.
  • Change long text fields (MEMO): Mdb or supports this value unless the text is formatted to rich text. It also does not support this value if you have the append only property enabled.
  • Modify links to external files: Removes links to Excel spreadsheets in .xlsx format, Access databases .accdb, and Windows SharePoint Service. One option to keep the information is to import the data directly.
  • Modify the passwords that have the new protection method: Access versions prior to 2007 do not support the new security encryption. In these cases it is better to remove the password before conversion.

How useful did you find this content?

Click on a star to rate!

Average score 0 / 5. Counting of votes: 0

So far, no votes. Be the first to rate this content.

I'm sorry this content was not useful for you!

Let me improve this content!

Tell me, how can I improve this content?

Deja un comentario