I've created a SQL dB and set up a Access ADP as the front end. I've now got to the point of testing it and what I've come up against is that only one person can be in it at any one time because when someone else tries to open it says that it will be opened read-only because the file is locked for editing by another user. Would this be something to do with permissions on SQL or something. Can anyone help ?
