Re: Access locking for certain users

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 04/28/04

  • Next message: Juan Carlos: "Cannot update the records in the page" 
    Date: Wed, 28 Apr 2004 14:59:25 -0400

    Joel Roland wrote:
    > I'm running access 2002 on my network with multiple
    > users.
    >
    > Every time user A access the database no one else can get
    > in.

    Check the windows permissions on the folder. All users need read, write,
    create, delete permissions on the folder. If the first person in doesn't
    have create permissions, they can't create the associated ldb file, and the
    mdb will be opened exclusively. 

    -- 
Joan Wild
Microsoft Access MVP
  • Next message: Juan Carlos: "Cannot update the records in the page"

    Relevant Pages

    • Re: Have database mismatch, can I move NTDS.dit and Exchange to new identical server?
      ... Check the physical location of the Winnt\NTDS\ folder. ... Check the permissions on the \Winnt\NTDS folder. ... as it may not be the database that is the ... MCSA + Exchange ...
      (microsoft.public.win2000.active_directory)
    • Re: Help - locked out of database
      ... IT checked all the permissions and everything seems to be ok. ... "Joan Wild" wrote: ... I have poured a year into this database - is there someway to recover this? ... You need, at minimum, modify permission on the folder. ...
      (microsoft.public.access.security)
    • Re: Shared v. Exclusive Access
      ... The folder wherein the frontend resides grants Full permissions to the ... When I open the database, however, I don't get the message boxes. ...
      (microsoft.public.access.security)
    • Re: error updating access database using where on number column
      ... The solution was not to set permissions for the folder, ... Again, pardon my crankiness, this is my third monday this week and it's only ... In order to use a database concurrently ...
      (microsoft.public.inetserver.asp.db)
    • Re: Display of Message "You do not have eclusive access toa databa
      ... > in the foder that has the database. ... >> permissions on the folder, then have one of them open the folder in ... >> permissions on the folder. ... >> Ian Shaw wrote: ...
      (microsoft.public.access.security)