Unspecified Error when connected to MS Access

Question

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....

Sondre Garmo · Answer

I had the same problem before I closed all my connection to the Access database. Now it works great. Search in your code you have for all connection to the database and follow the code to end of your connection to check that you have closed it. It's easy to disregard one line.