#Error

  • Thread starter Thread starter Greg Potteiger
  • Start date Start date
G

Greg Potteiger

I have a database and I have a row where all fields show
up as #Error in the table view.

Access wont let me delete the row and it crashes if I try
to repair.

Any ideas how to delete this row??

Thanks
 
First, make a file copy. Second, make another copy. On the copy. try
importing the tables into a new database. It should leave the corrupted row
behind. Do it soon as it may corrupt the entire table.

Did I mention that you need to make a copy?

Seriously, don't work on your original, you need it to send to a repair
service should you not be able to repair it. One other thing. There is a
utility on Microsoft's site called JetComp.exe. which fixes things that
standard repair often can't do:

http://support.microsoft.com/default.aspx?scid=kb;en-us;273956&Product=acc20
00
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
First, make a file copy. Second, make another copy. On the copy. try
importing the tables into a new database. It should leave the corrupted row
behind. Do it soon as it may corrupt the entire table.

Did I mention that you need to make a copy?

Seriously, don't work on your original, you need it to send to a repair
service should you not be able to repair it. One other thing. There is a
utility on Microsoft's site called JetComp.exe. which fixes things that
standard repair often can't do:

http://support.microsoft.com/default.aspx?scid=kb;en-us;273956&Product=acc20
00
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
You may have already tried this...

1st - backup your current database - and make sure you can get into the
copy.

You can create an empty database and export the table to the new database -
Definition only.

If you can determine which record it is, Export the table to a spreadsheet
or CSV and delete the offending record there.

You should probably delete the table from the original database - then
compact/repair.

Import the SCV or Spreadsheet into the new database. See if you can
compact/repair that database. If it's ok - export it back to your original
database.

Good Luck!

YTB
 
Back
Top