Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Windows 8 Access 2013 ODBC Drivers

Posted on 2013-05-29
4
Medium Priority
?
1,932 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 58
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 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

670 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