MS Access database OLEDB Exception: Too many active users

Last Reply on Apr 19, 2014 04:52 AM By Mudassar

Posted on Apr 19, 2014 04:49 AM

A database I had was running slow on my server, then I took my database did a compact and repair in Access, then copy it back over to the server. It started running well, and now it seems to go to an error screen more quickly now, rather than just locking up, which it was doing yesterday.

This is the error I am recieving, any suggestions or help would be greatly appreciated.

thank you

Posted on Apr 19, 2014 04:52 AM Modified on on Apr 19, 2014 04:52 AM

MS Access database is not meant for too many concurrent access and hence you are getting this error. If you are expecting more number of users, my recommendation is switch to SQL Server or MySQL database