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
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