Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Aug 2002
    Location
    Wichita, Kansas, USA
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    lock file error (2003)

    This is version 2003 Access but creating files with 2000 format.

    I'm not sure if the following problem is an Access problem that can be resolved or if the problem is coming from ADS.:

    We have a directory folder that UserGroup1 has read/write access; UserGroup2 has ReadOnly Access

    If someone in UserGroup1 opens the database first, UserGroup2 gets a "cannot create lock file" error when they try and open the database

    If someone in UserGroup2 opens the database first, they get the read-only message, which is correct, but when UserGroup1 opens the database they get "read only" access to the database also (instead of read/write).

    The table of data is linked to a SQL backend which does have a timestamp field in it.

    Does anyone have any idea what we can do to fix this problem? The only thing I can think of is to give everyone read/write access at the directory folder level and then use a Workgroup file to create security for 2 user groups on the database itself.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: lock file error (2003)

    Access requires that all users have full permissions at the file/directory level - if some users have only read permission at the file/directory level, you'll get the behavior you describe. You'll have to assign user-level permission using a workgroup file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •