I have a process that has to write data into a dBase IV file. To access the dbf file I use the following connection string:

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Data;" & _
"Extended Properties=dBASE IV;"

I've noticed that after inserting and deleting several times a big number of records, the size of the dbf file continued to increase. As far as I know, records in dbf files are not deleted phisycally, just marked as deleted. Does anybody know how to compact programatically the dbf files?