I'm using Microsoft Visual Basic 5 and ADo 2.1 to access data from FoxPro DB.

When I delete records (from VB) everything works OK. But, in the database just performs a logical deletion, physically the data is there. This will give a problem because the database could turn very big in a few time.

If I go to Visual FoxPro and execute the 'Pack' command, the records are physically deleted. I'm doing this often but I think it doesn't must be in that way.

Any ideas will be appreciated.

Thanks