Last post Jan 09, 2012 12:49 AM by aspdeveloperstrongname
Jan 03, 2012 12:37 AM|sathya6482|LINK
Is there a way to connect to a Microsoft Access 2000 Database from Microsoft Visual Studio 2010 in a 64 bit machine? If there is any way, please provide me a sample code in C#.NET. Advanced thanks for your kind help.
Jan 03, 2012 01:23 AM|aspdeveloperstrongname|LINK
The Microsoft OLE DB Provider for Jet and the Jet ODBC driver are available in 32-bit versions only. You can't run them in 64 bit mode.
For example, you have a 32-bit application that uses the Microsoft OLE DB Provider for Jet. If you migrate the application to run in the 64-bit mode, the application cannot connect to the data source by using the Microsoft OLE DB Provider for Jet. This issue
occurs because the application requires a 64-bit version of the Microsoft OLE DB Provider for Jet.
Note also that a website can be either an 32 bit or 64 bit application.
We still have a solution for this..
If you run a program in a 64 bit environment and need to utilize jet to open an access, excel or text file there are several options to make this work.
Check this for download
It is possible to open Excel, Access and text files on 64 bit systems.
You can either configure your app to go 32-bit or you can change your application to use the new 64 bit drivers.
Hope it helps!!
Jan 03, 2012 01:59 AM|sathya6482|LINK
Thanks a lot for the information.
Jan 09, 2012 12:49 AM|aspdeveloperstrongname|LINK
You are welcome..
Please mark it as answer if you feel it to be the answer so that others can follow this. If any more quries, feel free to ask..