John, I have never never never had a need for pessimistic buffering and see no reason in a production environment to use it at all as allit does is lead to exactly the problems you are getting. If you really want to use that type of file/record locking the why not use rlock() and flock() which give you better control over the VFP locking features.
Either use Optimistic buffering or even just jet VFP take care of the record locking itself (No Buffering). Take a look at Andy Kramek's paper on Record Locking in a network environment if you want a really good explaination of Optimistic buffering and how to control it. http://www.tightlinecomputers.com/Downloads.htm The article is called A Guide to Buffering and Transactions in VFP. Dave Crozier The secret to staying young is to live honestly, eat slowly, and to lie about your age -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John J. Mihaljevic Sent: 14 November 2006 15:12 To: [email protected] Subject: RE: What other users are in what form? And deciphering Read Events. > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of MB Software > Solutions > > Had that happen to me years ago with VFP5, iirc. What VFP version are > you using, and are you accessing VFP tables for the backend directly, > with some buffering, or using views, or what? Sorry...shoud've passed along more details. I'm on VFP6. These are just tables in a database - no views are involved. And I'm using pessimistic buffering. John "The difference between a successful person and others is not a lack of strength, not a lack of knowledge, but lack of will." - Vince Lombardi * All mail scanned by Norton AntiVirus. No AV software on your computer? Remove me from your address book, please. * Please respect my privacy. Do not forward my address to anyone else or include me in emails sent to multiple recipients. Use BCC. [excessive quoting removed by server] _______________________________________________ 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.
