Originally Posted by
rpeare
Here's the issue (I've had it before), there is something going on between your webserver and your access database (they are on two different machines), and even short interruptions in communication will stop your Access database from working without closing the database and re-opening it. MS access is not good about re-aquiring linked tables if there's an interruption in communication. This isn't an Access problem it is an issue between your web server and your computer hosting the MS Access database. If you have someone that's able to monitor the traffic between the two computers and verify there's a problem you may be able to track down which machine it is and fix it from there.
If the problem happens every few minutes (as it was with me) finding this problem is really the only solution.
If the problem happens, say, every few hours, you can build an event into your database to re-establish the links so you don't have to exit and come back into the database.