Help-truth about MS Access

[greg252]

Can someone tell me what the deal is with Access. I've had more people in the last month tell me that Access was working great for them on the net. I didn't think that Access was multi-threaded.
What gives?

Pros/ Cons/ input appreciated.

[edwardsbc]

Working great under what kind of load? Using Access as a backend on co-processed web server will actually have reasonable performance under light loads. As I understand it, however, the ODBC driver serializes requests to the database. As you get more and more concurrent query requests response time will suffer. If your data set is small and load light, Access will work. Just don't expect it to scale.