Home > OS >  Delphi 10.4: Connection to a MS Access 2019 Database
Delphi 10.4: Connection to a MS Access 2019 Database

Time:12-23

After repairing a crashed MS Office 2019 I did not manage to reinstall the correct MS-Access database driver for my ADO Connnections on a X64 Win11 system.

I tried to install alternatively the database engines 2010 and 2016, but neither of them was shown.

Does anyone have a hint? Oswald

CodePudding user response:

Solution:

  • Download 32-bit Driver
  • From command-line: Driver.exe /passive

Oswald

CodePudding user response:

Here a longer description of the way to a solution:

My skills are just scratching the surface, I'm afraid. What I know: The IDE of Delphi 10.4 is 32-bit und doesn't work with the 64-bit database engine of Microsoft. The complete process for getting a working system has been:

  • Download both (32-bit and 64-bit) drivers
  • First install the 64-bit driver (not shown in IDE)
  • Then install from command-line 32-bit driver: accessdatabaseengine.exe /passive Trying to install a 32-bit driver on a 64-bit Win11-system will raise an error, while not having installed the 64-bit driver first.

Maybe somebody is able to explain this in more depth. I am not…

Oswald

  • Related