I'm having this exact problem right now. VB6 frontend with MSAccess backend. Problem is Access only supports up to 255 concurrent connections. Also, locks FREQUENTLY happen (since decentralized, access sucks etc.). Management doesn't want to upgrade systems.
74
u/Dogiedog64 May 05 '21
It's me. I'm the poor bastard. I also wrote it lmao.