#ERROR in TABLE

[Guest]

Help! Somehow a record in an Access Table (in a Split database) has #ERROR
#ERROR #ERROR in almost every cell, including an AutoNumber Field. It won't
let me delete it or change it. Can anyone tell me how I can get rid of it? I
think its causing alot of "Invalid Argument" messages to pop up (like when
they search the table). Thank You...

 

[Guest]

Try to refresh the link to the table.

 

[Guest]

Seemed to refresh ok (I ran the refresh from an MDE of the Split front end)
but still didnt eliminate the error record. I should tell you the #ERROR info
is in the back end. Would it be okay for me to run the compact and repair on
that or would I have to re-create the links and/or recreate/distribute the
mde?
Also, another dumb question: If i copy the be/fe to another folder and test
on that, am i in any danger of changing the original db? It is also linked to
a few iSeries files.
THanks,

 

[Guest]

By copying the DB to another location and the run compact and repair, there
is no danger of harming the original.
Before you try anything, make a back up.

Try first compact the BE, and open the table from there and see what happen.
If you compact the BE after you copy it to a different location, don't
forget that the FE still link to the original, and not to the copy.

 

[Guest]

Thankyou - compacting and repairing the back end did the trick. Thanks for
the hand-holding!