Cannot resolve backlink

[Peter]

Note: I have already posted this in another discussion group fox.vfp.setup
but I repost it in here since it should be posted in here instead.

What are the possible causes to get the error "Cannot resolve backlink"?

My understanding is that opening a dbf which has problem in locating its dbc
will get this error. Are there any other possible causes? If opening a dbf
can locate its dbc but the dbf structure is different from the information
recorded in the dbc, will there be an error and what is it?

Thanks,

Peter

[Dan Freeman]

If the DBC is deleted or moved such that it can't be found, you'll get this
error. Solution: always move DBF/DBC (and related files) as a set.

If the DBF structure differs from what's in the DBC you'll get any of a
variety of errors. VFP will object to the key being invalid, or tell you the
database needs to be validated.

This is why daily FULL backups are of paramount importance.

Dan

Post by Peter
Note: I have already posted this in another discussion group
fox.vfp.setup but I repost it in here since it should be posted in
here instead.
What are the possible causes to get the error "Cannot resolve
backlink"?
My understanding is that opening a dbf which has problem in locating
its dbc will get this error. Are there any other possible causes?
If opening a dbf can locate its dbc but the dbf structure is
different from the information recorded in the dbc, will there be an
error and what is it?
Thanks,
Peter

[Peter]

Hi Dan,

If the structure is different, will Cannot resolve backlink be one of the
possilbe error message?

Thanks,

Peter

Post by Dan Freeman
If the DBC is deleted or moved such that it can't be found, you'll get this
error. Solution: always move DBF/DBC (and related files) as a set.
If the DBF structure differs from what's in the DBC you'll get any of a
variety of errors. VFP will object to the key being invalid, or tell you the
database needs to be validated.
This is why daily FULL backups are of paramount importance.
Dan

Post by Peter
Note: I have already posted this in another discussion group
fox.vfp.setup but I repost it in here since it should be posted in
here instead.
What are the possible causes to get the error "Cannot resolve backlink"?
My understanding is that opening a dbf which has problem in locating
its dbc will get this error. Are there any other possible causes?
If opening a dbf can locate its dbc but the dbf structure is
different from the information recorded in the dbc, will there be an
error and what is it?
Thanks,
Peter

[Dan Freeman]

There is no error at that point. Any error that gets thrown comes after that
dialog.

But yes, error 1976 is "Cannot resolve backlink" (presumably if the user
clicks Cancel to the backlink dialog).

There's a complete list of error messages in the help file.

Dan

Post by Peter
Hi Dan,
If the structure is different, will Cannot resolve backlink be one of
the possilbe error message?
Thanks,
Peter

Post by Dan Freeman
If the DBC is deleted or moved such that it can't be found, you'll
get this error. Solution: always move DBF/DBC (and related files) as
a set.
If the DBF structure differs from what's in the DBC you'll get any
of a variety of errors. VFP will object to the key being invalid, or
tell you the database needs to be validated.
This is why daily FULL backups are of paramount importance.
Dan

Post by Peter
Note: I have already posted this in another discussion group
fox.vfp.setup but I repost it in here since it should be posted in
here instead.
What are the possible causes to get the error "Cannot resolve backlink"?
My understanding is that opening a dbf which has problem in locating
its dbc will get this error. Are there any other possible causes?
If opening a dbf can locate its dbc but the dbf structure is
different from the information recorded in the dbc, will there be an
error and what is it?
Thanks,
Peter