is there an autosave anywhere in access

ryetee

Registered User.
Local time
Today, 23:22
Joined
Jul 30, 2013
Messages
952
I have 2 small front end to an access database.
In one when I go into design mode for say forms and make any changes I get prompted as to whether or not I want to save the form on exit. I love this as I can play around and then say no to any changes,
The other front end seems to save automatically without asking. Bit of a problem when i made a huge change that didn't work.
Anybody know how I can stop this happening?
 
Hello,
May be Warnings were disabled in the second front end ?
Close the application and launch again.
 
Hello,
May be Warnings were disabled in the second front end ?
Close the application and launch again.

Closed, relaunched and still the same!
 
You launch the 2 front end from the same PC?
What 's happened if you launch the first front end from the directory of the second?
 
You launch the 2 front end from the same PC?
What 's happened if you launch the first front end from the directory of the second?

Yes (laptop). They are both in same directory.
 
It's surprising. Ms Access is the same. Try to set on warnings lauching a module :
Code:
Public Sub BackWarnings()
Docmd.SetWarnings True
msgbox "Warnings set ON !"
End Sub
 
I'm not sure that will help with this problem. In post #1 the OP speaks about opening the form in Design View.

Sorry. Indeed, now I see.

From my experience the single way is to recreate the form.

Start to design a new form.
Copy all the controls from the old form into this new one.
Copy also the code.
See if the problem persist.
 
I am wondering if the db might be corrupt. In every version of Access that I have used, after making changes to the design of a Table,Form, Report, Query I have always been asked to confirm saving the changes. I have never seen or heard of any setting that might change this behavior. Strange happenings in Access are often a sign of corruption.
 
Sorry. Indeed, now I see.

From my experience the single way is to recreate the form.

Start to design a new form.
Copy all the controls from the old form into this new one.
Copy also the code.
See if the problem persist.

It's every form! In the 1st front end if i even go into design mode when I close the form it asks me to save or otherwise. If I edit it does the same.
The 2nd front end doesn't.
 
I am wondering if the db might be corrupt. In every version of Access that I have used, after making changes to the design of a Table,Form, Report, Query I have always been asked to confirm saving the changes. I have never seen or heard of any setting that might change this behavior. Strange happenings in Access are often a sign of corruption.
Tried a compact and repair and it still persists
 
Look at if you have a line "Docmd.SetWarnings False" somewhere in your code without the reverse "Docmd.SetWarnings True" after.
 
Look at if you have a line "Docmd.SetWarnings False" somewhere in your code without the reverse "Docmd.SetWarnings True" after.

quite a few settings of both - also found a load of redundant code. will investigate further. watch this space!
 

Users who are viewing this thread

Back
Top Bottom