Access DB error: Cannot open Database ''
A number of sites we host use Access databases. Most are fine, but two of them in particular occasionally stop responding which causes the ASP page and the raw log to show the error:
80004005 Cannot_open_database_''.__It_may_not_be_a_database_that_your_application_recognizes__or_the_file_may_be_corrupt
I've been through MS Product Support and checked every possible resolution (permissions, shares etc) and it's none of these - I can rule everything out.
I know that Access databases aren't suitable for use with Web applications since they're not multithreaded but smaller sites can normally get away with it as they don't have much concurrent access - in fact these two sites are quiet and the problem isn't related to overload.
In fact it really doesn't seem to be related to *anything* - the databases just stop working occasionally for no reason. Rebooting IIS seems to release a lock on the file which resolves the issue.
Any ideas on what might be causing this from anyone who's seen it before? Many thanks.
