Closing a Database and not exiting Access

[Steven Chicago,Illinois]

My user would like me to switch the quit button from closing the database and
access, to just closing the database. She wants Access to stay up and allow
her to manually open up another database (avoiding the load time for access
itself). I searched for code examples, but only found mention of doing it
with no example code. Is it possible and could you show me the code?

 

[Roger Carlson]

Instead of DoCmd.Quit, use CloseCurrentDatabase


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L