MS access memory leak

Jet database uses in-memory cache which is set to infinite by default. If you are using Jet database in any of your process then make sure you set cache size to something definite otherwise your process will just continue consuming memory like anything. The cache size of Jet database just grows in size and there is no ways to reduce it (event connection release won't help in this case). Microsoft documentation says that you can set it through registry also. I tried to set it through registy but it did not get reflected. So setting it through code is the only option. Below are some useful links on this matter

http://support.microsoft.com/kb/248014

http://msdn2.microsoft.com/en-us/library/aa140022(office.10).aspx#adoproperties_connectioncollection