Confirm - which can be found in Advanced section. Never, never switch all three options off; leave them enabled. There are three settings; Record changes, Document deletions ux design course in chennai and Action queries which are designed to prompt the user before you delete records, objects and run action queries as once executed cannot be reversed.No locks - found in the Advanced section too and should be left like this as it will allow appending or importing data into various tables more freely and unless there are a large number of concurrent users on the system then this keeps the system free from preventing changes and restricting record and page conflicts.

http://www.chennaibizbook.com/VBA-Training/

Set Trusted locations - which is found in the Trust Center Settings (button) is where you can manage and prevent the horrible pop-up banner users see when starting a database file other than from the default location on your pc. You simply train the system by adding locations (paths) with the option of specifying sub-folders included to avoid the disabling of any macro and module based code that is lurking in the database file.Of course I could add another 5 options that I believe should be left alone and really only controlled via VBA code with the design intent of users being aware of how they wish to control an Access database.