I deployed an online quiz in my site using Access as my database. The question is randomly selected from the database one at a time so that multiple users using the application at the same time will receive a different question. The users answer is also stored in the same database every after each item.
I received some complaints about my application. The users had some problems on the access of the same database. Is the problem due to concurrent close and open of the same database? Or is it really true that Microsift Access is not capable of concurrent access for multiple users? I need some help about this...