Connect to MS Access DB (.accdb) Without "Access Database Engine 2010"

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!

So you're saying the current environment has 32-bit Office installed? If so, then build your C# app to target the x86 (32-bit) platform and use the existing 32-bit Access Database Engine. — Gord Thompson
– Gord Thompson, Commented Jan 6, 2016 at 20:09
Yes, the current environment has 32-bit Office and the current C# solution is a 32-bit solution and it works fine. I wish to convert the C# solution to 64-bit and I can't change the organizational Office 32-bit installation. That's the problem. — Hanoch Giner
– Hanoch Giner, Commented Jan 7, 2016 at 11:19
Thanks for the reply, I wish to do so because of many reasons that are relevant to my project but not to this post. My question is "how" and not "why".... — Hanoch Giner
– Hanoch Giner, Commented Jan 7, 2016 at 13:25

Gord Thompson · Accepted Answer · 2016-01-07 14:52:53Z

3

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.

answered Jan 7, 2016 at 14:52

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connect to MS Access DB (.accdb) Without "Access Database Engine 2010"

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related