John,
>Thanks for the reply. Unfortunaly I can't search for a thread number as I am not a member of the UT.
You can find the thread by clicking the calendar link and finding the messages for September 27, 1999.
>I guess you can work both sides of the street depending if the app is multi user or not... My current thinking is to make all apps multi user so the need to handle deleted records without opening the table in exclusive...
Much better to have one development approach instead of two different ones. If you need to pack tables, you can handle that in an automated process after hours, unless your app is up 24 hours a day with users constantly in it.