Problems updating linked SQL table in Access97

[jmoldover]

I'm having a funny problem with a SQL table that I've linked into an Access97 front end. The table opens in Access97 and displays all of the data, but when I try to update the data in a record, I get an ODBC error as follows:
"ODBC -- update on a linked table 'dbo_Manual Select Include' failed"

After clicking on "OK", I get the following:
"[Microsoft][ODBC SQL Server Driver] Timeout expired (#0)"

However, if I first add a new record to the table and then delete it (from within Access), I can then update the records with no problems.

I've checked all of the permissions on the SQL end, on the database as a whole, the specific table, and the individual columns in the table, and have set them all to allow anyone to update the table (even though the ODBC link I created and am using should connect the user as "sa&quot, but this has not resolved the problem.

Any ideas? I've experienced this problem on multiple computers with multiple network logins, so it does not appear to be a network issue, especially since it will allow me to do the updates once I've added/deleted a row.

 

[cmmrfrds]

Does the sql server table have any bit data type fields, that is, a field defined as bit in sql server?

 

[jmoldover]

No -- all fields are varchar.

FWIW, I did find (about 2 hours after posting the question) that it suddenly stopped giving me the error message, and allowed updates normally. I don't think I did anything differently, it just decided to work...