Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Access set up ODBC connection in control panel

Posted on 2012-09-03
5
Medium Priority
?
605 Views
Last Modified: 2012-09-03
Hi

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.

Thanks
0
Comment
Question by:Murray Brown
  • 3
  • 2
5 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 38360430
32 or 64 bit windows?
0
 

Author Comment

by:Murray Brown
ID: 38360443
I need to do that on machines with both so either will help
Thanks
0
 
LVL 22

Expert Comment

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

Accepted Solution

by:
Kelvin Sparks earned 2000 total points
ID: 38360528
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

http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

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.


Kelvin
0
 

Author Closing Comment

by:Murray Brown
ID: 38360545
Great. Thanks very much
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

578 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