Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Locked Database when other user opens it

    Hi all,

    I have created a simple help desk database in Microsoft access 2010, if the database is opened by another user and I want to open it it wont open but the problem does not happen if I open the database first before other users.

    Your help is much appreciated

  2. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    If you want more than one user to use the database, probably the way to go about it would be to split it in a front-end database and a back-end database. Each user could keep its own copy of the front end and all front-end DBs would use the same back-end database.

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Skender,

    You'll also have to set the record locking properties on your forms and update queries.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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