I've got a major problem with my company Intranet in that when several people are trying to access similar pages that use the same database I get errors saying 'cannot read database - file already in use'. It works fine if there isn't heavy traffic. I'm using an Access database.
Should this happen? i thought Coldfusion would be able to handle several requests at the same time. I may be being completely niaive here - I am a newbie.
Is there anything I that I could be doing that is fundamentally wrong? Is there anything I can do in the Coldfusion Administrator to stop this happening?
Any help gratefully recieved.
Thanks in advance.