Add New Data Source fails

Hi,

>>I have a Microsoft Access 235 database *.accdb file I want to add to a VB.NET 2012 Pro project, but get the error "Unrecognized database format".

For this error message, I suggest you to check if the right driver has been installed, please refer to the link below:

http://msdn.microsoft.com/en-us/office/cc907897.aspx

http://social.msdn.microsoft.com/Forums/enUS/accessdev/thread/99e2eedf-0a36-4d38-9713-f3c82018c804

Another possible reason is about what platform you compile this application, please refer to this link:

#Unrecognized database format when creating a data connection in visual studio 2010 professional

http://stackoverflow.com/questions/15030170/unrecognized-database-format-when-creating-a-data-connection-in-visual-studio-20

Usually you have two options: x86 and AnyCPU. If you compile for AnyCPU then your code is executed as 64bit code on 64bit systems or 32bit code in 32bit systems. If you compile for x86 then your code is executed always as 32bit code in 32bit and 64bit systems. So AnyCPU seems to be the obvious choice. Now imagine the Microsoft Team that develops the "Microsoft Access Database Engine 2010 Redistributable". They choose to build separate versions of their drivers. The result is: if you build for AnyCPU and run on a 64bit system where there is installed a 32bit version of the Engine you can't use their code. You need to install the 64bit version, but now you face the need to install the 64bit version of Office otherwise you can't work with that. Much better to switch your app to 32bit code and choose the x86 target platform.

---

<THE CONTENT IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, WHETHER EXPRESS OR IMPLIED>

Thanks

MSDN Community Support



Please remember to "Mark as Answer" the responses that resolved your issue. It is a common way to recognize those who have helped you, and makes it easier for other visitors to find the resolution later.