First, make a copy of the database, just for safety's sake. Then you need to create a new table with the same data structure as the old one, then run an append query that specifically filters out the one record that is corrupted. Finally, you can delete or rename the original table, rename the new table with the original table's name, and recreate any relationships involved with that table. You will lose the data for the bad record, but should be able to save all the rest.
Tobi -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of studentindia Sent: Thursday, October 06, 2005 8:40 AM To: [email protected] Subject: [AccessDevelopers] MS acesses record corrupted i am a table where on record corrupted. where i try to delete the record it says that the primary key was not found. can any 1 tell me how to get rid of that record. thanx in advance Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
