Someone said ODBC DSNs are bad and could slow down my site; how else am I supposed to connect to my Access, SQL server or Excel data content?
We recommend you try getting away from access databases, as it confines you to using older and slower technology that doesn't handle multiple requests very well. If you can't possibly use SQL, then here is a solution:
This is a common and well known issue with Jet/Access databases. Here's an article on 4 Guys From Rolla that we feel answers this very question and provides references to other articles on the same subject.