[AccessD] DB Corruption, Memo field?

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