Save on Exit Question

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

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" wrote in message
...
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

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


"Al Campagna" wrote:

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" wrote in message
...
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

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."

"Jeff" wrote in message
...
Thanks. I should have clarified we are using Office 2007. :-/


"Al Campagna" wrote:

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" wrote in message
...
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