Friday, December 25, 2009

How to enable connection pool in MS Access

I found out a property in the connection string with which you can enable connection pool while using MS Access as your database

Provider=Microsoft.Jet.OLEDB.4.0;OLE DB Services=-1;Datasource=Filename.mdb

The property in the red color will enable connection pooling. The reason to suggest this is it improves the performance remarkably.

No comments: