> > We now have 25 simultaneous users on our system and things are starting to > pop up errors like "record is in use by another". >
I've seen a bunch of older code that uses a series of REPLACE commands: REPLACE field WITH value REPLACE field WITH value instead of a single REPLACE. Every line requires a new record lock. Consolidating those might help. If parts of the application have been updated to use grids, that might cause problems, too. VFP has a nasty bug in the grid that causes it to write changes to the first visible record instead of the current one. This counts as the change of another user when VFP moves off the current record. Christof --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cal4qjhjuu-d4wt0ysitg-tmayjk3ejomzye+o4dhwm2v5ho...@mail.gmail.com ** 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.