John J. Mihaljevic wrote: > I'm on VFP6. These are just tables in a database - no views are involved. > And I'm using pessimistic buffering. > >
Why have you chosen pessimist buffering? This keeps the record locked for the whole time you are editing, which will be giving you the "Record in use by another" messages. Optimistic buffering only does the locking when you tableupdate. If you only want one person editing a record at any one time, you could store the username plus datetime of edit, when then first edit, then pop up a message for other users who want to edit. You then clear these fields when you save or cancel editing. You will also need a method for someone to clear the "lock" in case of any crashes. HTH Peter _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
