I have a question about best practices as far as opening and closing the database connetion in my app. Currently I am opening and closing each time the database is accessed with a query or update. Should I be doing this? It’s a lot of opens and closes. Or maybe I should just open when the user signs on and close when he/she signs off. Or some other idea? Do you have any ideas or suggestions for me on this? I'm using VB.net to access an Access database.