[AccessD] DB Corruption, Memo field?

http://rogersaccesslibrary.com/Otherdownload.asp?SampleName='Fix%20Corrupt%20Access%20Database%20v4.5'

Some good reading from Jerry Whittle


David

----- Original Message ----
From: Lawrence Mrazek <lmrazek at lcm-res.com>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Wednesday, December 27, 2006 6:39:43 PM
Subject: [AccessD] DB Corruption, Memo field?

Hi Folks:

Using Access XP/2002

I'm currently troubleshooting a corruption issue that I think I've narrowed
down to a specific table in my DB (we'll call it tblAnnoyance <G>), as I can
import / export every other table in the db without any problems except
"tblAnnoyance". 

Thus far, I've tried all of the built-in tools (Compact and Repair, the Jet
Utility), with no luck ... The compact gets to a certain point and then
Access shuts down. 

I've also tried to browse the table to see if I can find any errors, but
once I get to a certain point, the db shuts down as well. I've found that if
I delete a memo field in the table (tblAnnoyance) using a copy of the
database, the Access will compact and repair. So I guess the problem is with
the specific memo field, but I really don't want to have to delete the
field, since I've been having problems copying data from the field as well. 

Any hints as to where I should go from here?

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
mobile: 314-496-1645 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com