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