Looking for deleted records in a linked .dbf file

B

Bill Lentz

I have some linked .dbf files which contain records that are marked as
deleted with the native application (FoxBase) I happen to know that
the files have not been packed, and therefore the record should still
be there.

Is there a way to "see" the deleted records in Access? If so is there
a way to 'undelete' one of the records? (I've been given the command
lines to do the job with mfoxplus, but I'm much more comfortable
working in Access.)

Thanks
Bill
 
K

Klatuu

Have you tried linking to one of the dbf files to see if the "deleted"
records show up?
It has been over 5 yrs since I did any FoxPro and much longer since any
FoxBase, but as I remember, there is no field in a dbf that will tell you
whether a record is deleted, it is hidden, so you just had to look for
Deleted().

If they don't show up in Access, you may have to use Fox to undelete them.
 
C

Cindy Winegarden

Hi Bill,

I'm not sure whether the FoxBase tables can be accessed with the FoxPro ODBC
drivers, but there is a setting that will allow you to see deleted records.
Click the Options>> button beside the Browse... button and clear the Deleted
box, which is equivalent to Set Deleted Off in FoxPro. However, you will
probably have no way to tell which rows are deleted and which are not.
 
K

Klatuu

I think it will depend on the version of FoxPro the dbf files come from. I
don't know about later version, but up through (I think) FoxPro 3.x the dbf
format did not change from Foxbase.
 
Top