April 9, 2024
Contribute to the Microsoft 365 and Office forum!
Click here to learn more 💡
May 10, 2024
Access Forum Top Contributors:
64 bit driver for DSN for MS access database
It is giving me an option for only SQL server database.
Defining connectivity to MS access database through DSN is very critical to my ASP applications working through IIS (internet information services) After reviewing the solutions on the web I concluded currently there is no 64 bit driver.
Should I downgrade my windows 7 professional to 32 version
Report abuse
Thank you.
Reported content has been submitted
Hi smantha11,
Currently Microsoft does not have any 64 bit ODBC drivers available for the Office products.
However, as long as the application that you want to connect to is 32 bit, you can use the 32 bit ODBC drivers to create the DSN. To get to the 32 bit ODBC drivers, the 32 bit Data Source administrator must be used. The 32 bit Data Source administrator must be launched directly if you are using a 64 bit OS. The file should be located at the following path:
c:\windows\sysWOW64\odbcad32.exe
Hope this helps!
Kathy
Report abuse
Thank you.
Reported content has been submitted
66 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=e
This file will add Access to the list of file types in the ODBC administrator.
Not sure if its 32 or 64 bit. But it worked on a machine running 64bit Win 7
Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2009 Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries
Scott<>
Blog: http://scottgem.wordpress.com
Microsoft Access MVP since 2007
Report abuse
Thank you.
Reported content has been submitted
11 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Question Info
Last updated March 28, 2024 Views 252,355 Applies to: