Connection Pooling & MS Access.

Question

Can I dynamically change connection pooling parameters? Sometimes I have error when close connection. Thanks In Advance! Jon. http://www.naptaxes.com/AAJ/ [Searching jobs from your desktop and automatically sends resume.] --------------------------------------------------------------------------------

spgilmore · Answer

I could only guess but I would say no. As I understand it connection pooling will only work with connections that have the EXACT SAME connection string (this is knowlege regarding classic ADO not ADO.NET so I could be wrong). Changing the connection pool parameters changes teh connection string (unless you know another way to do it). BTW why are you using connection pooling with MSAccess? Access supports relatively few concurrent users and you might benefit from using a single connection to an Access database and just working with the one connection. It won't do you much good to use multi threading on Access and if you only use one operation at a time you might as well just share the connection object between dataadapters or datareaders.