Hi, I have a database which I have split front end and back end. When some users are accessing the front end, it is locking the database - both front and back. It doesn't happen every time a user is in the database - seems very ad hoc as to when it happens. Does anyone have any ideas how I can prevent this happening. I had used a similar set up last year and it worked fine once we had ironed out teething problems for users being able to access it but never had this issue arising.
Any help greatly appreciated.