Microsoft Access automatically saves any changes made to data in fields without me having to hit a "save" command. Is there any way of formatting the database to prevent unintentional editing of data when searching records or making new entries?
as far as i know there is not a way but then my experience may not be as extensive as some other peoples. when you are working in form view the database has been setup and to change settings like this could upset it and could comprimise your table integrity and relationships. unless you feel it is necessary to your everyday work i would leave well alone and edit any errors you make.