Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Ontario, Canada
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sharing Databases (2003)

    Hey there ... Quick question about sharing Access on a network. When two people have a database open, it seems that the second user (that being the second person to open the database) is unable to make changes. Is this a setting that can be turned off or changed? I haven't been able to find anything about it, one way or the other, in Access.

    Both users are listed as admins to the database and have full rights to make changes - provided they aren't the second person to log in.

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

    Re: Sharing Databases (2003)

    Do you mean make changes to records in the tables, or make changes to the design of forms etc.?
    If the latter, it is by design - starting with Access 2000, Access requires that you have the database open exclusively if you want to apply design changes. In older versions, this was not required, but that could lead to nasty conflicts and to database corruption.
    If the former, also check that all users have modify (read/write/create/delete) permissions on the folder containing the database.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing Databases (2003)

    Hi Hans, I hope that you can help please:
    On our LAN we are trying to share our Access 2003 db. No luck so far. We don't want to simultaneously change the structure, but do want to be able to edit the data, in different records, while we are together. Is there a way to do this please? (I have looked at the security setting and granted permissions on both pc's.
    Last question: We have set up the method of getting to the programme by hyperlinks and constantly receive the Security warnings. Is there a way of turning this off for our LAN?
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

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

    Re: Sharing Databases (2003)

    Make sure that all users have modify permissions on the folder that contains the database.
    Make sure that you have set the Record Locking property of the forms used to edit data to None, or to Edited Record, not to All Records.

    About your other question: do you really mean hyperlinks, or shortcut files?

Posting Permissions

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