64 bit driver for DSN for MS access database

Anonymous

I have windows 7 professional 64 version on my laptop. I tried locating DSN (data source name) for MS access data.

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

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

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

0 comments

Answer accepted by question author

ScottGem 68,840 Volunteer Moderator

You can download the drivers here:

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

0 comments

50 additional answers

Anonymous

2014-01-10T07:18:27+00:00

Create DSN on Win-7 for Access

1:-> click on "start" button -> click on "control panel"

2:-> change view in control panel -> view by : small icon

3:-> click on "Administrative Tool".

4:-> Duble Click on "Data Sources(ODBC)"

5:-> Select "User DSN" tab.

    -> Select "Access database" option

    -> click on "ADD" button

    -> click on "Select" buttton

    -> select "Microsoft Access Driver(*.mdb,*accdb)

    -> click on "Finish"

6:-> new window open.

    -> type Data Source Name = CustomeDSN (Note: Please type same to same)

    -> type Description= CustomeDSN

    -> click on "Select" button

        (note: select path from :c:/program file/smart solution/weighning management/system/WehingDB.mdb)

        (note: if WehingDB.mdb file not apear then please this location and copy provide admin right and share it.

               if again not apear then open explorer then cut that file on desktop then reastart computer and past it again samr location.)

7:-> click on "Finish"

note: after create DSN please open software and check its working.
Was this answer helpful?

0 comments No comments
Anonymous

2014-02-06T17:53:48+00:00

32bit DSN = C:\Windows\SysWOW64\odbcad32.exe

64bit DSN = C:\Windows\System32\odbcad32.exe

You can create an Access DSN in 32bit because the drop-down selection of available 32bit drivers will have an Access driver.

You can NOT create an Access DSN in 64bit because you will not find an Access driver in the drop-down selection of available 64bit drivers.

Problem: Creating a "Link" connection in SQL Server 2008 64bit R will NOT display any of the 32bit DSN connections you create. Only 64bit DSN connections are displayed for selection. Hence the problem.

Solution: Anyone have a 64bit Access client? I'm still looking.
Was this answer helpful?

0 comments No comments
Anonymous

2014-04-04T15:17:16+00:00

it didn't worked

same problem occurred again
Was this answer helpful?

0 comments No comments