Looking for some general advice: I have taken over support of a large and complex web site, which uses multiple Access databases. At present it makes use of the MS Jet database engine (Provider=Microsoft.Jet.OLEDB.4.0). (as well as MySQL, used in a Snitz forum).
After solving many specific problems I am left with a nasty situation, where certain database calls appear to cause the Jet engine to freeze, and everything halts until pages time out and the blockage is cleared. After such a timeout everything runs nicely until the next incident.
These incidents are random. There is some evidence that this occurs when multiple pages employ the recordset.RecordCount method at the same time.
Is this a known problem? Where can I find information on similar problems?
Should I move the entire site away from the Jet database engine to another provider?