Microsoft Access (.mdb) vs. Microsoft Access (accdb) and target cpu

Question

  Stop me if I am wrong, the Access .mdb files requires jet.oledb provider to access the databases and requires X86 target cpu.  Not Anycpu or X64 

 What does the Access .accdb require along with the (ACE OleDB) provider, what target CPU does it require AnyCpu, x64 and/or x86.

The reason I ask is that if I continue with .mdb I run into problems with drivers for a
USB-DIO card that requires x64 OR Anycpu to work.

Answer 1

What about your other thread? I still think this is not the right forum to ask because it's not an Interop question.

You're right about the Jet engine. It's 32 bit only, so you must compile to x86 to use it. It only reads mdb files, not .accdb files.

ACE OleDb: whatever is installed. AnyCPU should be fine. This is only a problem if only the 32 bit ACE OleDb version is installed on a 64 bit system. Then you either need to compile for x86 or install the 64 bit engine. The Ace OleDb can also handle .mdb files.

---

Armin

Answer 2

  Being new to this I do not know the proper threads to put my questions under.

Answer 3

  Where do I get the 64 bit ACE.OLEDB?    Like you said above, it was ok on my small
  program that was compiled as X86.   But I forgot my main program is AnyCpu and 
  the machine is a 64 bit system. 

Answer 4

Microsoft Access Database Engine 2010 Redistributable

Take the x64 version.

---

Armin

Answer 5

  Tried to install the x64.exe but keeps coming up and telling me to uninstall two programs.
  1.) Microsoft Office Professional Plus 2010 and 2.) Microsoft Office Single Image 2010.
  Was able to uninstall Professional Plus 2010 but could not find Single Image 2010.  Went
   to Control Panel, Uninstall programs and could not find it.   Any ideas where it might be
   hiding.

Answer 6

I'm afraid, this is beyond my knowledge.

---

Armin

Answer 7

  So who can I talk to.....  My computer is now messed up.  I still can not find  the Microsoft Office Single Image 2010 to uninstall.  I can no longer use visual studio to connect to access database until the 64 bit ACE.OLEDB is installed.  none of my programs work...