Advice on Connection - where should it be?

Ok.. I am still a newbie working on access. So far, what I have done is I have included code to open a connection in every module i.e. add, update and delete. Obviously there is duplication of some code.



The one I am currently working on will probably be used by 5-6 people. My question is in the projects, is it good to open a single connection and if yes, where should it typically be opened?



Or should every single sub have its own connection? I have seen examples wherein they mention currentproject.connection which makes me think they have a single connection.



Any advice would be much appreciated.



Thanks

Advice on Connection - where should it be?