#ERROR in TABLE

  • Thread starter Thread starter Guest
  • Start date Start date
G

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...
 
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,
 
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.
 
Thankyou - compacting and repairing the back end did the trick. Thanks for
the hand-holding!
 
Back
Top