I have an application where I need to delete records from a DBF file. I am accessing the DBF through OLE. When I run a DELETE SQL command, some programs (such as Excel) see that the records are deleted, but there is a specific program that this is for that still sees the records. Is there a way that these records can be completely removed from the file through the OLE data provider?

Thanks,

Brian

BJHill2112

Its been a while since I've worked with a dbf table, but I recall that so-called "deleted" records were simply TAGGED as deleted in the table, and invisible to all but low-level operations. If I remember right, the way to remove "deleted" records is to make a copy the dbf table.

They should also go away if you backup/restore or complress the database.

The problem is that they are stand alone DBF files, not part of any real database.

Brian