I restored a backup, that seems to have repaired the table. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tracy Pearson Sent: Tuesday, August 07, 2012 9:56 AM To: [email protected] Subject: RE: corrupted table and database issues Richard Kaye wrote on 2012-08-07: > Did you use the RECOVER option when executing VALIDATE DATABASE? > > Make sure you have a copy of the table, index and memo, if any. Once > the DBC is repaired, you may be able to simply ADD TABLE. If the recover does remove the table reference from the DBC, you will need to re-establish any metadata (primary key, default values, field captions, etc.) for that table after adding it back. > > -- > rk > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of James Harvey > Sent: Tuesday, August 07, 2012 9:45 AM > To: [email protected] > Subject: corrupted table and database issues > > We had a power outage, and apparently this corrupted a table "hshealth'. > > When I try to 'use' the table I get an error: Variable pk_hshealth > is not found. > > This is the name of the primary key field, which is an auto increment field type. James, It sounds like the table or index is corrupt. Make sure you have a backup as it is now. Delete the associated CDX file and see if the table will open after giving the error that the CDX file is missing. If it does, recreate the indexes. Otherwise, you may need to restore the table from a backup. Tracy Pearson PowerChurch Software [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
