auto save

[Sarah at DaVita]

I am not sure what happen but now when I open my database and start a new
query I requires I save it. Instead of giving me the option to click no it
only has the yes and cancel button available. Can someone help?

 

[Smartin]

I am not sure what happen but now when I open my database and start a new
query I requires I save it. Instead of giving me the option to click no it
only has the yes and cancel button available. Can someone help?

Hi Sarah I had a similar problem recently with Access 2003. It seemed
my database was corrupted. You should try compact/repair first, but
this did not solve my problem.

The only solution I could find was to create a new database and
manually import the stuff from the corrupted database. Do not import
the queries directly though: You must open each query in SQL view,
copy and paste the code into new queries in your new database.

Hope this helps!

 

[mitchj]

I am not sure what happen but now when I open my database and start a new
query I requires I save it. Instead of giving me the option to click no it
only has the yes and cancel button available. Can someone help?probly