Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • Last Modified:

Manually save in Access 2007

Access automatically saves updates by default. If you update a field in a record and then leave the record the update is automatically done.  We want to turn this off so that the user must Save the database manually.  Is there a way to turn that automatic feature off?  
Thanks,
Misty
0
AliantIT
Asked:
AliantIT
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
No, you cannot turn off this feature if you use bound forms. If you work with Unbound forms you have full control over this, but of course you are also responsible for managing adds, edits, update and deletes. If you're not familiar with unbound forms, they're basically forms with NO Recordsource, and the controls on those forms have no ControlSource).

You can "trap" the Save event and ask the user if they want to save the data at that time, but they still must either save the data OR undo the form (i.e. remove all changes since the last save).
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now