how do you delete an invalid argument in access

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

Guest

In our table we have 1 line that has #Error all across the line. We have all
the information above and below but we can't get this line to delete. It
continues to give us a "invalid argument" and it just keeps popping up and we
can't do anything in our table. We don't know what happened to cause this.
Can anyone help us?
 
Hi Deb

This problem is the result of a data corruption, and is not caused by
something you did.

To rebuild your database, see the article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html
particularly the 2nd symptom:
Symptom: Some table rows show #Deleted

As the article explains, you can rescue your data into a rebuilt table,
provided you do not refer to the problem row. For example, if the problem
row is autonumber 88, you would rescue the data with a query that has
criteria of:
<= 87 OR >= 89
 
Deb said:
In our table we have 1 line that has #Error all across the line. We have all
the information above and below but we can't get this line to delete. It
continues to give us a "invalid argument" and it just keeps popping up and we
can't do anything in our table. We don't know what happened to cause this.
Click to expand...


Could be a corruption in the data. Make sure you save the
file immediately in case your attempts to fix it makes it
worse.

The only time I've seen this kind of thing, I could open the
table in sheet view, select the previous through next record
by dragging the mouse, and then use the Delete key to dump
all three records. Compact the file and then reinsert the
deleted data.

Since all bets are off if it is corruption, there's no
guarantee that will work for you.

Another idea is to use Insert Into queries to select all the
records before and after the damaged records and copy the
good data to another table.
 
Back
Top