Save error

[Duncanmcl]

In a multi user Access environment, I included on the quit routine a docmd.save before the actual quit. Seems this causes Access DB to be put in a state by user type error. Is this 'save' command at the global level...saving for all users within application? Is save included within the 'quit' command at the local user level?

 

[JoeAtWork]

If you highlight the "Save" method in DoCmd.Save and press F1 (which opens Help), you will discover that this method is not for saving data. Instead, it is for saving changes to the design of a form, report, query, etc.

 

[Duncanmcl]

Thanks....no need to worry about user data being saved ...its automatically at quit....I was trying to over compensate and protect....but data is saved within the forms presented.