Access auto saves when closing, doesn't give me choice

[mn62223]

I'm using a new laptop with Access and it auto saves changes on closing. Is there a default, I can set, so I get an option menu of saving or not saving changes? Thanks

 

[AlexCuse]

Access is a database application, it does not work like your typical desktop app (excel, word). Once a change is made to a table's contents, it is automatically saved.

Access will prompt you when you close a form or query that you have made changes to, but not a table (unless you make design/layout changes).

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[mn62223]

Alex, that's my problem. When I open a query, modify it, and then close it I don't get a prompt me to save or not save as it just closes and auto saves the change(s). I've been using Access for years, on different computers, and it has always given me an option to save. This is a brand new Toshiba M115 laptop with new Access and it doesn't default to a choice.

 

[JoeAtWork]

The behaviour you describe could occur if the following code were run:

DoCmd.SetWarnings False

However, that should only last for as long as the current Access session.

Are you seeing this in all MDB files you open, or just a particular one?

 

[mn62223]

It happens on all queries I open, modify, and close. I don't know if this makes a difference or not but I did drag the original data base from from an HP laptop to a removable drive and then did the same to my Toshiba laptop. The other thing I notice is when I'm opening the data base I get a Security Warning asking me if I want to open or cancel my request. I never got this on my HP laptop.

 

[PHV]

menu Tools -> Options ... -> tab Search/Replace:
are all the confirm checkboxes ticked ?

The spelling may be different as I don't use an US version of ms-office.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DwayneS]

Check for auto-open forms with vb code in the On Open property. I've seen cases where someone for some reason puts docmd.setwarnings false in a place like that. If that is done, your warnings could be all gone.

Dwayne Streeter, CPA, CITP

http://www.cpe-interactive.com