Graceful Database Shutdown

[TastyWheat]

I recently got a corrupt backend with the standard "unexpectedly quit Microsoft Access" message. This type of corruption (backend) has never happened before so I'm a little worried. I think I've taken the standard preventitive steps, but I'm hoping I can do more.

I guess I have two questions but my main one is, what's the most graceful/ideal way to close an Access database as to reduce chances of corruption?

My other question is, does the size of the database have any bearing on it's corruptibility?

 

[Dreamweaver]

You can loop through all open forms closing them then run an exit command but you'll need a boolean in the db main screen to stop users clicking the X top right as this should be checked in the on close if false cancel=true but when they use your exit toolbar button you set the boolean to true.

Look in help files for allforms collection, on this site for the isopen function,

mick