ODBC fails in Access works in Excel - SQL 2005

[Markvand]

Hello,

I have an odd situation with ODBC connection in Access 2010. I can't link any tables to SQL 2005 due to timeout error. The strange thing is that I can easily get the data through ODBC with Excel.

I thought it might be an issue with Windows 7 64bit and Office 2010 bit, but the same problem on the machine with both software in 32 bit version.

It also fails without antivirus and firewall. I reckon it has to be Access, I've changed OLE/DDE time out settings without success.

Any suggestions would be much appreciated.

Mark

 

[boblarson]

How are you trying to link the tables?

 

[Markvand]

In Access -> External Data -> ODBC Database and then I'm choosing the user DSN source. I can't even get the window with tables, just timeout error.

 

[boblarson]

How have you set up the DSN? What ODBC Driver have you chosen? Just an FYI - for using 32 bit Access on 64 bit Windows you need to open the odbc manager NOT from the control panel but from C:\Windows\WOW64\odbcad32.exe.