I have a MS Access database (2007-2013 file format). It is really behaving terribly.
1. It has created a duplicate row with the same Indexed, duplicates "NO" field.
2. It is consistently going into Recordset not updatable and locking the users from Updating any records or creating new ones.
3. I have tried to Compact and Repair mutliple times.
4. I tried to open a fresh new DB and tried to export the tables and received the following:
Reserved error <Item>; there is no message for this error. (Error 3000)
The database is split, I have a FE and BE.