#deleted rowsc access 2010 backend
Posted on 2016-11-04
A row of data in one of our table seems to have corrupted. f I delete it, it vanishes, then reappears when I reopen the table. I did a compact and repair which permanently removed the troublesome row - but its had other impacts on the database, i.e. wont let users add new rows via the FE, and seems to of stripped a primary key for some reason. I do have backups, some before that dodgy row was in the table, but reverting back is going to lose a lot of data. Is there any other technique rather than compact and repair to get rid of it?