Hi David,

Thanks for the reply. I am much more inclined to have one approach to keep up with.

I worked out an approch to recycling records see my reply to Rick. If I missed anything please let me know.
Thanks

>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.