Save on Exit Question

[Jeff]

I have a database set up for one of my users and he insists that when he used
to close the database, after making changes to the table, the program would
ask if he wants to save it. Now the program automatically saves the changes
and closes.

He does not want this. If someone makes a change, then changes their mind,
rather than going back through and manually editing the changes, they can
just close the program and not save. Makes sense to me.

I havew been searching all over for this setting and can't seem to find it.
Any suggestions??

Thanks,

Jeff

 

[Al Campagna]

Jeff,
For 97 and 2003, check under Tools-Options-Edit/Find-Confirm, and try
cehcking those 3 boxes.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Jeff]

Thanks. I should have clarified we are using Office 2007. :-/

 

[Al Campagna]

Jeff,
Click the round Microsft Logo on the upper right.
In the lower left of the dialog box, select Access Options.
Select Advanced, and see the section Confirm.
Try checking all 3...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."