>This is a problem that I run into occassionaly and it's happening right now.
>
>In my production reservation system, any user which tries to update a field in the UNITS record will get the error "Record in use by another user." I've tried this on four different terminals.
>
>It doesn't matter which record in the table you try to change; you still get the error.
>
>The system is using local tables on a Novell file server. Approximately 30 terminals have this table open.
>
>The program is based on Visual FoxExpress version 5.0. The UNITS form has its own data session using optimistic table buffering.
>
>If I use EDIT/BROWSE from the command prompt I can change records in the UNITS table without any problem.
>
>Presumably one terminal has some kind of lock on this table which is hanging things up.
>
>Any ideas what the problem might be?
>
>Peter Robinson


Peter,

Are the users updating the table through a grid on your form?

Cathy