That is not something that can be turned off. You would have to do a LOT of
extra work like use unbound forms and do all saves with code and/or use work
tables for your form instead of the real ones.
Best is to learn how to use Access at it actually works instead of how you think
it should work.