Access set up ODBC connection in control panel

Posted on 2012-09-03
Last Modified: 2012-09-03

How do I set up an ODBC connection in the Windows 7 control panel
that can be used by an Access 2003 database to connect to an Access 2007 database.

Question by:murbro
    LVL 22

    Expert Comment

    by:Kelvin Sparks
    32 or 64 bit windows?

    Author Comment

    I need to do that on machines with both so either will help
    LVL 22

    Expert Comment

    by:Kelvin Sparks
    And what version of Access 2007 (32 or 64 bit)?
    LVL 22

    Accepted Solution

    The first thingt that you need to do is to install the Access 2007 ODBC driver. You've probably noticed that you can't see one.

    Download from

    and install.

    For a 32 bit version of windows 7 goto control panel>Administrative tools>ODBC cionnections and create. Choose the new Access driver for .mdb;.accdb and follow the usual steps.

    For Windows 64 bit you cannot use the control panel - this uses the 64 drivers and Access cannot use these. Goto Windows/syswow64/ and find the file ODBC32.exe (or a file very similar - I'm not on a 64 bit PC at the moment and can't remember the exact name). When you have the right file the ODBC panel opens - just use it as you usually would to createthe connection. (Once the driver above is installed, you'd be able to create this from with Access 2003.


    Author Closing Comment

    Great. Thanks very much

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now