Personally I use one connection for a solution that resides in a class project removed from the main project. Depending on the operations dicates if the connection stays open or is closed after operations.

MSDN VS2010 sample solution, refer to the data access project for MS_AccessConnection.vb