Damaged database 1

[jimdevon]

Help! I manage a client server dbase with the tables split to the server, and each client with his/her own specialized application. One day last week, I came in to the office and someone informed me that there was a problem with the computers. I found corrupt data is one record in the table. I first tried to repair the table without success. Next, I restored the previous day's back up, and told them to renter the missing information. The system is operating, but if I run compact/repair a new database is created with the name db1. If I do not erase this the next time db2 is created. These are duplicated of the tables. How Can I correct this problem? Do I create a new database and import the records? Thanks in advance for your help.

 

[TempestLost]

This is a sticky one.

I've had this problem a few times myself and this so far is the only way I've found in solving it.

1. Disconnect the database/computer from all network activity
2. Backup everything before continuing
3. Go to File>Get External Data>Import and select the database which contains the table
4. Delete all the records in this copied table ( if original table called table, new table will be table1)
5. Open up original table and select all records, copy them and go to new table and paste them.

It will not copy the corrupted record. You might have other problems along the way but I've found this to work every time I've had this problem. If someone has a better suggestion, I would be very grateful.

Good luck.