Autosave need to stop it!

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

I inherited a database. When you first go in and say I
update a table or query I am prompted to save yes, no,
cancel. However, after I run a report, press a button on
a form, and if I go into a query make changes it saves my
stuff with out prompting, I can not even cancel out, it
just saves my changes. What can I do? Does anyone know
what I should look for in the code to stop this? I looked
for the word disable but it is not their? BY the way it
effects all my database unless I close out of access
completely...

Please any help or suggestions,
Thanks...
 
Jean said:
I inherited a database. When you first go in and say I
update a table or query I am prompted to save yes, no,
cancel. However, after I run a report, press a button on
a form, and if I go into a query make changes it saves my
stuff with out prompting, I can not even cancel out, it
just saves my changes. What can I do? Does anyone know
what I should look for in the code to stop this? I looked
for the word disable but it is not their? BY the way it
effects all my database unless I close out of access
completely...

Please any help or suggestions,
Thanks...
Click to expand...

It's not clear to me whether you are talking about data changes or
design changes. However, I suspect that somewhere in the code (or
macros) that is executed in the process of running the report or the
form, warnings are turned off by the DoCmd.SetWarnings VBA statement or
the SetWarnings macro action. The correct approach, when it is
necessary to turn warnings off, is to turn them on again immediately
after doing whatever needed to be done without them. It seems likely
that the creator of your database failed to do so.

If the database logic is implemented in VBA code, look for the statement
"DoCmd.SetWarnings False", unaccompanied by a "DoCmd.SetWarnings True".
 
Back
Top