[AccessD] DB Corruption, Memo field?

Mark A Matte markamatte at hotmail.com
Thu Dec 28 10:43:43 CST 2006


Larry,

Its been awhile since I've dealt with corruption...There was an extensive 
discussion here, summer '05 I believe, you might find it in the archives.  
Another method I've used in the past was opening the table in VBA as a 
recordset(NO sorting) and looping through the records one at a time.  I 
think you can then use LEN() of the memo field(or field that is corrupted) 
to test for errors/value.  At this point you can do 1 of 2 things...or both:

1.  Test the LEN() and append the good records and skip the bad.
2.  Test the LEN() and skip the GOOD records and append the PK of the bad in 
a new table(so you can look at the bad later.

If you can't get it to work...I would be happy, if you want/can, to take a 
stab at it.

Good Luck,

Mark A. Matte

P.S...In '05 someone on the list asked me to write an article, or something, 
about isolating/removing corrupt records.  About the same time I ended up 
having a couple of major surgeries and completely forgot about it until this 
thread came up.  I want to apologize to Someone...but not sure Who.  If 
someone reading this is that Who or Someone, I apologize...and if there is 
still a want/need for the article, outline, or whatever it was...please let 
me know.  Thanks, Mark A. Matte



>From: "Lawrence Mrazek" <lmrazek at lcm-res.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] DB Corruption, Memo field?
>Date: Thu, 28 Dec 2006 10:10:09 -0600
>
>Thanks Gustav and Susan:
>
>No dice on Susan's idea ... Still received the error message and shutdown
>(in Excel this time! <G>).
>
>Gustav's idea should work (hopefully), since I can browse the records OK up
>until a certain point. I'll let you know my results.
>
>Thanks again!
>
>Larry Mrazek
>LCM Research, Inc.
>www.lcm-res.com
>lmrazek at lcm-res.com
>ph. 314-432-5886
>mobile: 314-496-1645
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
>Sent: Thursday, December 28, 2006 4:22 AM
>To: accessd at databaseadvisors.com
>Subject: Re: [AccessD] DB Corruption, Memo field?
>
>Hi Larry
>
>Perhaps you could attach the table from a new db.
>The create a query
>
>   SELECT TOP n * FROM tblTable
>   ORDER BY ID ASC
>
>Narrow n down to return as many records as possible.
>Now reverse it to pick from the bottom:
>
>   SELECT TOP n * FROM tblTable
>   ORDER BY ID DESC
>
>The combined output from these two queries should retrieve all but the
>corrupted record(s).
>
>/gustav
>
> >>> lmrazek at lcm-res.com 28-12-2006 03:39 >>>
>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
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Get FREE Web site and company branded e-mail from Microsoft Office Live 
http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/




More information about the AccessD mailing list