How can I retrieve the whole recordset on a form

[P. Scaram]

I am using an access form bound to a SQL view on the SQL Server. I was using
the form in filter mode so that my client could search on any field he liked
and then get the data on his screen very powerful and simple. However I
started getting locking problems . The searches are returning 2000 records
but long ones and the fetch is not completed so when the user goes to another
form to update the record he gets Odbc time out. I saw on the enterprise
manager the view sets Share locks on the tables. That locks the update.

The first question is how can I set MSaccess 2000 to fetch all the records
always.

The second thing I noticed is that when after displaying the records I
return to filter mode the cursor is not released and the locks continue to
show on the SQL Server. This makes things worse because the locking continues
when the records are not even displayed.
I also have the impression that when I close the form the locking does not
go always away.

Any solution for that, to disconnect or close the recordset somehow and on
which events.

I would most obliged if you answered.

Thank you in advance

P. Scaram

 

[P. Scaram]

Dear Sir Madame,

I have not received an answer to the question. Please answer. The fetching
of the records in some cases is fixed by doing a movelast, movefirst on the
recordset.

The locking while in fiter I cannot do anything about.

Have you got any ideas.

Thank you