Access ODBC on Windows 7 Professional

[JScannell]

I tried creating an ODBC client and got an error popup. I Googled the problem and was told I had to use a 32-bit ODBC tool. I was able to create a client that way, but my web app still has the same problem as before.

Microsoft provides an extremely complicated dialog about 32- and 64-bit ODBC issues. I don't understand it at all.

I was able to create a 32-bit client but it doesn't seem to work. Does anyone know what I should do?

Thanks in advance,

Jerry Scannell

 

[trevorwilliams2]

Just fishing here....

If you are trying to ODBC connect an access front end and it is a new Win 7 machine / upgrade you may have trouble connecting to your target server if network discovery is not enabled on the client machine.

Try navigationg to the target server via network neighborhood and you will be prompted to turn it on on, if it is not enabled.

I have run into this on a few new machines here in the office.

 

[JScannell]

The error popup occurs as soon as I click the Configure button. The popup says:

The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver could not be found. Please reinstall the driver.



Jerry Scannell

 

[trevorwilliams2]

It'd sounds like an MDAC problem. Assuming your on a 64 bit machine there is a lot listed about Win7 64 and MDAC issues.

I picked this link up while doing a bit of digging around.

http://social.technet.microsoft.com...l/thread/7c20296f-6184-4c02-a616-2c6bd0bba3c9