I have a remote view in the DE of a Form. When the form is opened and while it stays open, SQL Server keeps a Tabel Intent Lock on the table. This is sometimes causing lockups when another user tries to update.
The remote view is a simple, one table, no where condition view, updatable, defined in the DBC.
What is causing this lock to be maintained?