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
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 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply