Hi people,

I'm using ADO to connect my application to an MS Access Database (2000).
I remember reading somewhere that it's not a good idea to have a lot of connections to your DB. How do i make sure that only one connection is open at any given time. I do make a number of different connections to my db, some that update and some that simply query my tables.

Thanks all for the help.

How many concurrent clients will be using your application ? What driver are you using in your connection string ?