The Save command on the toolbar is to save structural changes to objects in
your database, not for saving data. There is another command that will save
a record on demand. The behaviour you mention is by design. Access will save
any changes when you leave the current record, whether that be to go to
another record or by closing the form, query, or table. In a form, you can
do something to abort this behaviour. In the Form's BeforeUpdate event, you
can prompt to save changes and give the use the option to cancel. However,
this will happen for every record change.
Example:
If MsgBox("Save Change?", vbYesNo+vbQuestion)=vbNo Then
Cancel = True
Me.Undo
End If
Also, in the Form's Error event you will need the following:
If DataErr = 2169 Then Response = acDataErrContinue
--
Wayne Morgan
MS Access MVP
"Christopher Koh" <ch******@yahoo.com> wrote in message
news:2f*************************@posting.google.co m...
how do you stop Access from saving any changed data in your tables and
queries?
like i just add or change data on the table/query tables,then click on
X (exit)because i have no intention of saving it but access still
automatically saves it even if I did not press the save command on the
menu/toolbar? What is the solution for this? help thanks!