Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2003
    Posts
    4

    Question Unanswered: Can Access Lock Users out of a File?

    I need to create a DB that will keep users from accessing the same file. Essentially locking other out when one user is accessing the file.

    Is there a way for access to do this? Any help is appreciated.

    Thanks, Max

  2. #2
    Join Date
    Aug 2003
    Location
    Bosnia & Hercegovina
    Posts
    57
    is this about mdb/mde file locking or general file locking?

    access itself does not lock files, except it's own when compacting....

    but you could create function that does it for you and put it in access....

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    if your "file" is an access table that you are feeding to a form, your form has
    Properties ¦ Data ¦ Record Locks = All Records or No Locks or Edited Record

    if you choose All Records, second and subsequent users of the form can see data but not edit (and get a beep & status msg if they try).

    if your "file" is not an access table - what is it?

    izy

  4. #4
    Join Date
    Aug 2003
    Posts
    4
    No idea. This is all in the beginning planning stages.

    What I'm suppose to make is a document management type program. But have no idea.

    Does anyone know of any code to help me get started.

    Thanks for the help

  5. #5
    Join Date
    Aug 2003
    Posts
    4

    file locking

    Originally posted by Strucnjak
    is this about mdb/mde file locking or general file locking?

    access itself does not lock files, except it's own when compacting....

    but you could create function that does it for you and put it in access....
    It's regarding general file locking. I need the users to view files (like in explore), the admin will need to assign a folder/file to a user to work on. That folder will now be locked so no one else can open it and make revisions to it, or undo the others work.

    I hope this makes sense. Your help is appreciated

  6. #6
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    This sounds like something you would need to use API for.
    Try going to allapi.net They give a pretty decent explanation
    for each API call, and good examples of how to use it in VB.
    Inspiration Through Fermentation

Posting Permissions

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