Access Database
Options
As you were designing this database, the Microsoft Access program proofed
your queries and reviewed your code. Where does Access keep those settings?
Try it:
Enable Error Checking
Go to Office->Access Options.

Select Object Designers.
At the top of the Object Designer list are the
default specifications for Tables, Queries, Forms and Reports.
Scroll to the bottom and you will find the Error Checking
illustrated here.