mdb/accdb to use with Access database engine

Question

Hey

I need to create an Access database in Office Access and make the tables and fields, then deliver the blank file with the vb.net app which will use Access database engine 2010 and OleDbRerader to work with the database.

Just need to decide between mdb and accdb, I don't need user-level security, replication, SharePoint Outlook integ, or Multivalued fields

What I do care is the performance speed and size of database itself, also there are many tools which can remove the mdb password easily, is it the same for accdb?

Which Office version to use for creating the mdb/accdb blank database? 2010/2013/2016/2021

Somewhere I read that there's versioning issues so use the 2010 to make the database, but somewhere else told to use the latest 2021 to create.

thanks in advance

Answer 1

Hi @StewartBW ,

If performance and size are your primary concerns and you don't need the advanced security features of ACCDB, you might choose MDB format. However, if you prefer better security and potential compatibility with newer features, ACCDB would be the better choice.

Best Regards.

Jiachen Li

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

A MDB MS Access file type is more then old.

Use current and supported MS Access version, at best the latest, and current file formats.