>>The Help File says I should be able to lock 8,000 records per work area. But I am limited to 500 cumulative, in VFP 5.0 AND FPW 2.6.
>>
>>Am I doing something wrong?
>Matt,
>
>Out of curisoity, why lock 500+ records, why not just lock the file? File locking would be faster and easier to keep track of.
I have a number of tables where batch adds/updates are made and I don't want to lock out users from updating/adding records on/to other batches. What I sacrifice in performance, I make up in functionality.
Actually, I'd probably be better off by using record level flags instead of locking each record in a batch, but this is a legacy 2.5 app that will be phased out within the next 18 months. We are placing a band-aid on it to make it multi-user.
I'm open for suggestions if you have any.
Matt McDonnell
...building a better mousetrap with moldy cheese...