Microsoft Access assistance

  Munchkin 21:35 26 Sep 2006
Locked

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?

  Harpur 22:59 26 Sep 2006

are you entering data through an interface or directly into a table format?

  Munchkin 23:11 26 Sep 2006

I usually work with the data from a form view as opposed to working directly from the source of the data, ie, the underlying table.

  Harpur 23:27 26 Sep 2006

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.

harps

  Chris the Ancien 23:45 26 Sep 2006

The only way is to 'undo' a record before moving on to the next one.

Access was designed like it is to prevent inadvertent 'forgetting to save' actions from data input people.

Sorry.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?