Linking SQL tables into access

[matlaw]

I successfully linked some tables, then performed some queries on a SQL tables in Access, which were fine. Adding a little more selection criteria brought up an ODBC failure error.
I tried performing the same thing using a view in sql (which worked) and then linking that view into access. When trying to open this in Access the same ODBC error "ODBC - call failed (error 3146)" came up.
I have checked the dsn and everything seems fine.
Does anyone have an idea what I should check next.
any help would be greatly appreciated.

 

[tlbroadbent]

3146 is a generic connection failure message. Do you have any additional details from the error message? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[CosmoKramer]

Two things to consider:

1) The Access help says: "This error may occur when the ODBC data source is on a network drive and you aren't connected to the network."

2) If it worked before, until you added additional criteria, look at the ODBCTimeout Property for your query. The default setting is 60 (seconds). Try changing this to 0, or no timeout.