problems with an Access 2003 database (mdb)

Romeo Boboc

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 ?

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Javeed M Shaikh15y ago
Accepted 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 Boboc15y ago
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 Boboc15y ago
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 Shaikh15y ago
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 Boboc15y ago
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 Shaikh15y ago
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 Boboc15y ago
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 Shaikh15y ago
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".