I am writing a DAO to Access application in which I open the DB and create recordsets every time a new form is loaded throughout my app. Can the DB be opened in one location that can be shared by the entire application. Then create your recordsets and queries based on that open connection rather than closing it and opening several times while the app is running. Can the DB open be put in a module? Would like to clean out my code a bit and feel that opening and closing the db several times in the code is not very efficient!