>What is the best way to handle record deletes in a multi-user environment? Can I do a pack from a form with a buffer mode of 3 'Optimistic Row Buffering'? I know I need to use the file exclusivly, but when do I process the delete? I know I could have a seperate table to show which files need to be packed, but when would I issue the pack?
Probably the best way to pack the deleted records is to perform it in certaind period when users are off the system and the administrator can use the tables exclusively.
>Also how do I get the deleted() records not to show on the form?
You should have SET DELETED ON (SET DELETED is scoped to the current data session.)
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison