I think a record is causing my database to close

[Guest]

I think I have a faulty record in one my tables. Because when I try and copy
the table it shuts the whole database asking me to send error report. It then
creates a backup database for me but the problem remains in the backup.

I think its a faulty record because in the form when I do find then if i
look in the whole form then it crashes and shuts down but if it looks in a
particular field. But I can't find this record - what should i do?

 

[Arvin Meyer [MVP]]

I think I have a faulty record in one my tables. Because when I try and copy
the table it shuts the whole database asking me to send error report. It then
creates a backup database for me but the problem remains in the backup.

I think its a faulty record because in the form when I do find then if i
look in the whole form then it crashes and shuts down but if it looks in a
particular field. But I can't find this record - what should i do?

First, make a copy of the database so you can always have a clean one to
work on. Working on the original may make it impossible for a repair service
to fix it. Then try a Compact and Repair. If that doesn't work, download a
copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. What I do for a single (or a few) bad record is to
copy the last half of the bad table to a new table. If the bad record is in
that, it won't copy correctly. Then try the last quarter. What you are
trying to do is to narrow it down to just the bad records. If the database
is not very big, you'll find it in a few minutes.

Unfortunately, some corruption cannot be fixed - you may need to create a
new database, import what can be salvaged, and recreate the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Have you tried Compact and Repair, to try and resolve the problem?

A couple of other things...Have you copied that table, with data? Does it
still crash?
If so, then I would suggest running searches, across each field, until you
find the field with the offending data. Then you will need to try and find
the record.

Hopefully you are able to find it, and delete the record.

Good luck.

Sharkbyte