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