Posted by George on 10/02/42 11:53

Access 2002
SQL Server 2000
ODBC Linked Tables

I have a user who gets an ODBC timeout message when trying to save a new
record in a form. I looked at the locks on the server and that user was
locking himself out. On the same server I can enter records fine with
that form, except when he's in there, he's using the same application
(copy of).

The form he's using is a simple one bound to a query thus:
select * from table where 1=2
or something very similar so that it's always at a new record and
doesn't look at any others.

Any settings I should look at?

[Back to original message]