Access crashing at certain record

[karenbeth24]

When I scroll through a table in my database, every time I reach a certain
record, Access closes. Is there any way to delete what I am assuming is a
corrupt record?The last change I made was adding a field to a form, so I'm
not sure if it was something I did when I added this field.

Thanks!

 

[Allen Browne]

Firstly back up the database in case something goes wrong.

Then try a compact/repair.

If that doesn't fix it, you probably won't be able to delete it, because
Access will crash if you refer to it. So you will need to create a new
table, and import all the *other* records. The important thing is not to
refer to the problem record. Details in the example for #Deleted in:
Recovering from corruption
at:
http://allenbrowne.com/ser-47.html#RowsShowDeleted

 

[a a r o n . k e m p f]

if Access isn't reliable enough for you-- I wouldn't hesitate to move
to SQL Server.

 

[Gina Whipp]

Karenbet,

Sounds like corruption. I would try to first export the table to a text file
or Excel file, remove the bad record, recreate the table and bring all the
stuff back in. You could also try decompiling
http://www.granite.ab.ca:80/access/decompile.htm but not sure that will
help. I am assuming of course you already tried the compact and repair!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

message
if Access isn't reliable enough for you-- I wouldn't hesitate to move
to SQL Server.