you can always SET DELETED OFF SELECT * from file where DELETED() and append that to your archive since it is a good practice to have index on DELETED() anyway, you can have this query optimized Arnon >In a VFP 5.0 medical app, I need to move deleted records to an archive >file, before I pack (for chain of custody legal reasons). Does any one >have some sample code on how to simply do this. SHould I put some kind of >UI on it, or just do it behind the scenes when the file is packed? > >Thanks in advance. >