Solved

Windows 8 Access 2013 ODBC Drivers

Posted on 2013-05-29
4
1,854 Views
Last Modified: 2013-05-30
I am trying to set up an odbc connection to Access 2013 in Windows 8. No drivers listed to ad in system DSN other than sql.  Where do I find the proper driver?

Bill
0
Comment
Question by:DollarBillIA
  • 2
  • 2
4 Comments
 
LVL 57
ID: 39206300
Bill,

 Haven't used Windows 8 yet, but to get ODBC drivers for Access, one would install Access itself, or this:

Microsoft Access Database Engine 2010 Redistributable  
http://www.microsoft.com/en-us/download/details.aspx?id=13255

Be aware too that under Windows 7, there are two versions of the ODBC admin applet ODBCad32.exe.   One in C:\Windows\System32 and one in C:\Windows\SysWoW64.

The first is a 64 bit version and the other 32 bits.  Depending on your offce install, make sure your using the right one (from control panel, you get the 64 bit version).

 I would imagine Windows 8 is the same.

Jim.
0
 

Author Comment

by:DollarBillIA
ID: 39206308
The setup is the same as 7, with the 32 and 64, I am familiar with that. Is the Access 2010 driver usable in 2013? I have a pretty new laptop, my first foray into windows 8 and I've already had to do a reset once with a bad install of another program, so I am a little leery of getting one that isn't correct.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39207892
<<Is the Access 2010 driver usable in 2013? >>

  Yes.  The only change between 2010 and 2013 is the web stuff added in 2013.  Nothing for traditional desktop databases was changed.  Drivers are still all the same.

Jim.
0
 

Author Comment

by:DollarBillIA
ID: 39207907
Great! Thanks a ton, have a great day!

Bill
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The goal of this Micro Tutorial is to help navigate beginning users with the app store on Windows 8. It will explain exciting features how to maximize your PC through these apps. This will be demonstrated using Windows 8 operating system.
This Micro Tutorial will show you how to maximize your wireless card to its maximum capability. This will be demonstrated using Intel(R) Centrino(R) Wireless-N 2230 wireless card on Windows 8 operating system.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question