Help with Access 03 database in Access 07

[Don Moore]

I am working on a database that someone else built with Access 2003. My
machine only has '07 installed. When I open the database and make any changes
to a form, report, query etc. it does not prompt me to save changes when I
close the item. This is a problem since there are times when I don't want to
save the changes but it does anyway. I have looked through the database
options and do not see where to turn that feature on or off.

Any suggesions?

 

[Gina Whipp]

Don,

No setting that I am aware of... When was the last time you ran Compact &
Repair?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Jeanette Cunningham]

Hi Don,
If you change the data on a form or query, you won't be asked to save
changes. Access automatically saves changes to data.

If I make any changes in design view of forms, queries and tables, I am
always asked if I want to save changes when I close the object. The
prompting to save design changes to objects is automatic and can't be turned
off and on.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[John Spencer]

If you have a macro to SetWarnings False or VBA code that runs
DoCmd.SetWarnings False

AND you have no code or macro to SetWarnings back to true. THEN if the code or
macro has run you will not be prompted to save your design changes.

Try building a macro to SetWarnings to True or a little VBA sub to do this.
Execute the macro or VBA code and see if you still have the problem.

If so, you will have to track down WHERE SetWarnings is getting set to false
and then not set back to True.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Tony Toews [MVP]]

I am working on a database that someone else built with Access 2003. My
machine only has '07 installed. When I open the database and make any changes
to a form, report, query etc. it does not prompt me to save changes when I
close the item. This is a problem since there are times when I don't want to
save the changes but it does anyway. I have looked through the database
options and do not see where to turn that feature on or off.

Double check that all three check boxes at Tools >> Options >> Confirm
section - Record charges, document deletions and action queries are
checked.

Otherwise John's suggestion of Setwarning is likely the answer. Also
note that you must put setwarning in any error handling.

Also if you are using setwarnings due to docmd.runsql then replace
docmd.runsql with currentdb.execute strSQL, dbfailonerror.

Tony