June 21, 2005 at 5:02 am
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 ?
June 21, 2005 at 5:16 am
This sounds like an Access issue rather than a SQL Server issue - files do not "get locked for editing" in SQL Server. In Access, open the database and check Tools/Options/Advanced, ensuring that 'Default Open Mode' is set to 'Shared'.
Regards
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 21, 2005 at 5:22 am
This option is not in an access data project
June 21, 2005 at 6:43 am
We had the same problem here. Just ask the users to copy the file to their computer from a shared drive (where you release the new versions). That way you can update whenever you want and they can work without that warning. However this is only a warning, as annoying as it is. The file will still work without any problems.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply