Re: Multi user locking after first update



On Nov 13, 8:38 pm, "zmic...@xxxxxxxxx" <samlamb...@xxxxxxxxx> wrote:
On Nov 13, 9:06 am, "Keith Wilby" <h...@xxxxxxxxx> wrote:

"zmic...@xxxxxxxxx" <samlamb...@xxxxxxxxx> wrote in message

news:de012306-aa3d-4d9f-a737-c891ed90d276@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

@Kieth - All users have read/write permission.  Do they need more?

They need Delete permissions so that the lastuserout can destroy the
record locking file (ldb).

Kieth, that is priceless information.  Since I don't have control of
the shared drive, I can't change the permissions, so I will request it
tomorrow.  Cross your fingers.

Thanks,

Sam

Turns out all users have "Full Control" of the folder.

I have also tested the query itself without the form. When I update
the query, it locks the data until the data*** is closed.
.