CODEWITHSUNDEEP
c++databasems-accessnative
Eph Bee
Eph Bee

Reputation: 265

C++ manipulating mdb database

I want to create an app based on the content of a .mdb file, I searched for libraries to do that in native but they all needed requirements, I want a way to read these files using native code(C++) only, so I could use the library in multiple platforms.

Thx, Regards

Upvotes: 0

Views: 1573

Answers (1)

Mike Robinson
Mike Robinson

Reputation: 8945

The .mdb file format is specific to the Microsoft Access ("Jet") database engine, which is proprietary and specific to Windows. (Furthermore, it is an evolving file-format, although it does not seem to continue to be in active development now.) There is one, and only one, "correct" way to use it, and that is: to use Microsoft's library and surrounding framework, on Microsoft's operating system.

If, indeed, you need to use a "file-based SQL engine," "on multiple platforms," then I would cordially suggest that you instead use a database file format that was specifically designed for such purposes: SQLite.

Mind you, the two are not the same. They're the product of two entirely different design teams who had different purposes in mind. The SQLite team knowingly did not adhere strictly to the SQL standard. But, what they did do was to create a public domain(!) database engine, which uses a single file, and which was specifically designed to be cross-platform. Meanwhile, the Jet team designed their engine specifically, and solely, in support of the Access (and Excel) products of their company.

Upvotes: 1

Related Questions