Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 952
  • Last Modified:

ODBC Connection Error

We are having compatibility problems with Access 2003 to Access 2010.  All ODBC connections are correct but I still get an error message.   The connection setting work in 2003 and match the same configurations in 2010.  Please help.
0
bizzie247
Asked:
bizzie247
  • 6
  • 5
1 Solution
 
sammySeltzerCommented:
can you show your code, please?
0
 
bizzie247Author Commented:
How?
0
 
sammySeltzerCommented:
sorry, I meant to show the error message you are getting.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
bizzie247Author Commented:
I think that I figured it out but I can't figer out how to fix. In the ODBC Connection, there are no drivers installed by default via Office 2010. I installed full but still can't find it.
0
 
sammySeltzerCommented:
are you running it on 64bit os?

If so, try launching c:\windows\SysWOW64\odbcsys32.exe
0
 
sammySeltzerCommented:
Additional info that might be useful to you:

Click on Start > Control Panel > Use the drop-down-menu > Click on "All Control Panel Items" > Administrative Tools > Here you use the mouse curser to highlight Data Sources (ODBC ) and then you right-click on it. You click on "Run as Administrator" > Click on "Properties" > Security > Edit > Advanced > Here you have to turn on or simply "tick" all boxes under "Allow" except "Special Permissions" which should be left unchecked. Then confirm by "Apply" ,"OK" "Apply" "OK" to close everything. Now you can click on the Data Sources(ODBC) and under "Drivers" you will find everything there.

let me know if none of these helped.
0
 
bizzie247Author Commented:
Thanks, we don't seem to have SysWOW64\odbcsys32.exe anywher on the (64bit Windows 7 Ultimate) computer  and the other didn't work
0
 
sammySeltzerCommented:
Also, I know it sound silly but be sure that when you manually installed odbc from office 2010, that you didn't install 32bit version on your 64bit os.
0
 
bizzie247Author Commented:
No, actually, I am silly!!! it appears that I did have the 32 bit installed rather than the 64 bit. I had both versions in one source via volume lic and I assumed that it would pick the 64 by default on a 64bit OS. wrong!!! THANKS
0
 
bizzie247Author Commented:
Uninstalled the 32bit-installed the 64bit version and it worked!! Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now