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/