Failures caused by Name AutoCorrect
This feature was introduced in Access 2000. It tries to help users who rename a table field, so that queries, forms and reports automatically recognise the new field name. Microsoft has addressed some of the problems with this feature, but is it still buggy, incomplete, and a performance problem.
One of the known performance problem is the report is keep crashing, known in IPCA database.
Leave the option on when you creating new database as it helps you to track all the name changes throughout the database, but turn it off when the database goes live.