I have a database with about 14500 records. When working on it, the Data Sheet and one form are open.
I have noticed that if I use the Data Sheet to add data to fields, all goes well. But if I use the form, I get some crashes. The database is not corrupted and opens again with the last saved data.
To avoid these crashes, I’m trying to add data using only the Data Sheet but it’s hard to keep to this especially when modifying text fields that have many paragraphs. It’s often really tempting to use the form.
I have also noticed that the two views sometimes get out of sync, and the selected record in the Data Sheet is then not what appears in the form. Sometimes it’s really messed up. Closing the database and opening it again usually fixes the problem.
I’m wondering if the two problems are related and if there is a known problem with entering data in forms. And of course, if there is a way to avoid these problems.