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?
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?
Comment