Help! Access db won't allow me to exit a query without saving

[RDM23]

My access database is acting differently. If I build a simple select query, then want to exit, it only asks me to "save as". The only want to exit this query, is I have to save the query. The default name comes up with "query1". The only options are OK and Cancel. I am also noticing that if I run an update query, it updates the records, but doesn't give any confirmation that it updated records. It just runs and finishes without any popups. Anyone come across this before and have any suggestions on what it might be? I have rebooted and that still didn't fix. Thanks in advance for any assistance.

 

[PWise]

you must have set warnings to off

press <CTRL-G>

and in the immediate wnidow type

docmd.SetWarnings on

 

[RDM23]

Thanks for the suggestion, but this happens even when its not in the macro. Even if I open an existing query and make some minor changes to the query, then I close the query and it does not ask me if I want to save, it just automatically saves the query with the changes and then exits out.

 

[PHV]

In the Search/Replace tab of the menu Tools -> Options ... popup tick the 3 Confirm check boxes.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RDM23]

All 3 confirm options were already checked so it must be something else. Thanks.

 

[PHV]

And what happens in a brand new DB ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RDM23]

I created a new database and it appears to work fine. Must be something set on that database.

 

[PHV]

So, you may create a new DB and import ALL objects from the actual database.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RDM23]

Actually, after importing everything, it is still happening where it autosaves.

 

[dhookom]

Does any code run when you open the MDB? Do you get the same behaviour if you open the MDB while holding down the shift key and then modifying a query?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[RDM23]

It autosaves even if I hold down the shift key while opening access.

 

[dhookom]

Does this occur with every mdb you create?

If other people open your mdb, do they experience the same results?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PWise]

please check all you code for

docmd.SetWarnings

i have had this when Somewhere in code docmd.SetWarnings is set to false