I have a C# windows application which i have connected to MS Access database. The application runs the whole day. After every 2 hours I get "Unspecified error". This continues till i close and restart the application. I have gone through MS documentation saying that if a process creates more than 64 connections to the MS Access DB, this error can occur.
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B830133
Now, I have ensured that I close all the connections immediately whenever i open them. Still this problem occurs. Is there any way to check whether any connections are open or not? and also how can we detect, count and close all open connections? please help....