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: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James Harvey Sent: Tuesday, August 07, 2012 9:45 AM To: profoxt...@leafe.com 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. If I open the database and validate: Object #55 (Table 'hshealth'): Table is not in a database. I can open and modify the database, and the file appears there? After a number of attempts to rectify this problem I seem to be spinning my tires... 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 [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/DF1EEF11E586A64FB54A97F22A8BD04420D88E0714@ACKBWDDQH1.artfact.local ** 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.