Discussion Locked

Remove FoxPro deleted rcd with Access

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How can I remove deleted records in a Foxpro database with microsoft access? I can select and delete records to a foxpro file(with an access macro) but I can't remove the deleted records through access(as in reorg the file)Please e-mail me at khart@bommer.com if you need additional info to help out.
kris

1 reply

by stillatit

Foxpro keeps a flag for each record, saying whether or not it deleted. This allows the record to be restored if needed. The Foxpro "pack" operation physically deletes the records flagged deleted by copying the non-deleted records to a new file, thenrenaming.

In Foxpro, the DELETED() function returns whether or not a record has the deleted flag set.

Are you keeping the file in Foxpro format because you are still accessing it with Foxpro? If so, use PACK within Foxpro. If not, why not change the format?

Good luck.

This discussion is closed to new replies.