problems with an Access 2003 database (mdb)

Question

I have created a windows C# application with an Access 2003 mdb database.
I have compiled my application and I have obtined this error: "microsoft.jet.oledb.4.0' provider is not registered on the local machine".
In order to run my applicaton I did this: on my project (in Solution Explorer) clik right, -> Properties -> Build -> Platform target: x86 and my application ran correct.

My questions:
1. Can I create an x64 application with an Access 2003 mdb database ?
2. If yes, how can I do this ?

Javeed M Shaikh · Answer

But if you are using any driver specific feature then you might fall into issues, also you need to change the references and connectionstring in your version on WXP3; Otherwise you are good to go.

Romeo Boboc · Answer

Probably it's better to develop x86 application with Access 2003 database and x64 application with Access 2007 database; same application (source) with a little difference in code.

Romeo Boboc · Answer

Practically, I can develop my application on Windows 7-x64. Then I'll take source and I'll recompile it on Window xp sp3 x86 (with the right driver). Then I'll run it on Windows XP sp3-x86. Is it correct ?

Javeed M Shaikh · Answer

yes you can with the right driver: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255 Please make sure you have Windows XP Service Pack 3.

Romeo Boboc · Answer

If I'll install my Visual Studio 2008 Profesional and my Access 2007 on a 32 bits computer (windows XP), can I generate a x32 applicaton (with *.accdb Access database ) ?

Javeed M Shaikh · Answer

The answer to your question is 1. Yes 2. Yes Beginning in Office 2007, Microsoft Access gained a new file format with file extension *.accdb and additional functionality. Access 2007 (and later) database files are supported by the new Microsoft ACE (Access Database Engine) driver. The Microsoft ACE database engine is available in a version for 64-bit systems and can be downloaded directly (driver only) at: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255 Please do not forget to mark "Accepted Answer".

Romeo Boboc · Answer

1. Can I use Access 2007 database in order to create C# x64 application ? 2. Can I use Access 2010 database in order to create C# x64 application ?

Javeed M Shaikh · Answer

Jet 4 continues to be available as 32 bit DLL's, thus, 32 bit processes can continue to make use of it, this merely means there are no 64 bit binaries of the Jet4 drivers, thus 64 bit processes are not supported. If its a ASP.NET app, then you can create another app pool for enabling 32 bit applications and use the project. Please do not forget to mark "Accepted Answer".