Error: Could not find installable ISAM creating MS Access database

I get the error that the installable ISAM is not found trying to create an MS Access 2007 database. The connection string is:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Databases\Test.accdb;Jet OLEDB;Persist Security Info=false

I am using VS 2010 and .NET 4

Thanks in advance.
Hal

if you want to use that connection string, you must ensure clients have at least the Microsoft Access Database Engine 2010 Redistributable
which is downlodable for free at microsoft.com. You should take care to ensure you will install on client machine the correct engine for the target machine (x64 or x32). avoiding to try to install both - and your software too should be compiled x32 or x64 depending on target machine. AS you could not predict always what client machines (and if in case any engine is already there, might be even incompatible with your) usually we make a bootstrap that will take care of prerequisite and in case install it from web...
In any case, Microsoft Access Database Engine 2010 Redistributable is here
http://www.microsoft.com/download/en....aspx?id=13255

But before install the redistributable, look if it might be you are on a x64 machine and have the x32 engine (in which case you should try first compiling x32).

Thank you for replying. The project was compiled using the default of any CPU. I changed it to x86 and it is now working fine.

Regards,
Hal

that is because on target machine you have the x32bit of the engine. Thanks for feedback.
Cimpy