Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    7

    Post Unanswered: Multiuser Environment in Access

    We are developing an application in VB using Ms-access as DB, IN this at a time 10+ users are accesssing DB and updating recoreds. Most of the time we are getting error like...

    "could not update, currently locked"

    Database is placed in win 2000 server,

    My problem is how to do multiuser environment so that many user can access and update the Db simultanously without any problem.

    Guys your help needed urgently

    pankaj

  2. #2
    Join Date
    Sep 2003
    Location
    Caldes de Malavella, Spain
    Posts
    244

    Re: Multiuser Environment in Access

    Search Help for "Record Locking" to see your available options. In all versions of Access before XP, Access would lock a page of data (2K) when a record was being edited, rather than the individual record. This, I suspect, is the cause of the messages you are getting.
    Andy Briggs
    Elmhurst Solutions Limited
    Database Development and Consultancy
    http://www.elmhurstsolutions.com

  3. #3
    Join Date
    Mar 2004
    Posts
    7

    Re: Multiuser Environment in Access

    HI,

    We are already using Office XP and getting the same error

    "could not update currently locked"

    We need your help inn this regard

    pankaj


    Originally posted by andybriggs
    Search Help for "Record Locking" to see your available options. In all versions of Access before XP, Access would lock a page of data (2K) when a record was being edited, rather than the individual record. This, I suspect, is the cause of the messages you are getting.

  4. #4
    Join Date
    Mar 2004
    Posts
    29
    How is your front end displaying the data they are working with?

    If the front end of the database is displaying the same records that other users are working with you will make the displayed data (and possibly the whole record depending on the record locking method you are using) lock.

Posting Permissions

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