Does C++Builder work with MSAccess .accdb files?

Question

I am using C++ Builder 10.3. My last version was C++Builder 5 from 20 years ago.

My question comes about because I am totally new to this compiler and the Embarcadero blog sites are now 3rd party and not real usable.

Is it possible to access an MS Access .accdb database with the Interbase tools, or something else that comes standard with this compiler? My old version pre-dates .accdb.

Answer 1

FireDAC, which is Embarcadero's latest Database framework, supports connecting to MSAccess databases.

See Connect to Microsoft Access Database (FireDAC) in Embarcadero's DocWiki.

Answer 2

You can connect to MS Access database using ADO (dbGo) components. I am not sure if FireDAC is now supported on all editions of C++ Builder (previously, it was not the case). In case of ADO you would create a connection string that uses Microsoft.ACE.OLEDB.12.0 provider for .accdb database files, or Jet.OLEDB.4.0 provider for older .mdb files.