Connect to MS Access DB (.accdb) Without “Access D

Question

I'm working on a 64 bit C# solution and I wish to connect to an MS Access DB (.accdb file) without installing "Access Database Engine x64".

The "Access Database Engine x64" installation demand that the currently installed MS Office version is a 64 bit, which is not an acceptable demand in the company environment.

I realized that OLEDB and ODBC demand that "Access Database Engine x64" will be installed.

Is there another way to connect to the Access file?

Thanks!

Answer 1

I realized that OLEDB and ODBC demand that "Access Database Engine x64" will be installed.

Is there another way to connect to the Access file?

Practically speaking, no. A 64-bit .NET application needs to use the 64-bit version of the Access Database Engine to manipulate an Access database.

It is possible to force both the 32-bit and 64-bit versions of the Access Database Engine to reside on the same machine, but it is not recommended. It can cause problems with Office and is not a supported configuration.