Timeout For Single User

[OrWolf]

I have some queries running against linked tables in Access in my application. One user gets an error during the start-up of that application when the 5th of the queries is run. I used an ODBC trace to get some additional details but it hasn't helped. I verified that the OS, MDAC, and JET are up-to-date so any ideas would be greatly appreciated.

Working workstation:
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)
DIAG [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'MyDB'. (5701)
DIAG [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english. (5703)

Bad workstation:
DIAG [S1T00] [Microsoft][ODBC SQL Server Driver]Timeout expired (0)
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)

 

[SiJP]

Open the DB up on the broken machine, bypassing anystartup files.. press Ctrl+G to go into debug, and check tools > references.. see if there are any marked "MISSING:"

it may be that that particular PC is short of a few libraries...

.. just a thought :/

HTH's

------------------------
Hit any User to continue