Hi there and welcome
Have you tried to compact the back end (that holds the data)?
Choose the backend file and let it compact
When it has tell me if it still gives the error please.
ok, can you attach both files here and tell me the exact steps to replicate error please.
Sorry but without the file I have no way to troubleshoot this.
Telling me the symptoms does not help sorry, I would need to see the database in order to work out whats going wrong.
Is it possible I can connect to your computer and then see the database on your screen?
I made the offer for this, if you accept it we can do it this way.
I have opted out of working with you further on this in the event another expert can solve this without needing the database or access to your computer
You do not need to do anything, you will be contacted when an expert takes over