Re: "unable to lock database"

From: Jerry Spence (1_at_2.com)
Date: 05/01/04

  • Next message: Chris Barber: "Re: "unable to lock database"" 
    Date: Sat, 1 May 2004 23:11:59 +0100

    Thanks Chris - That's a good clue. I'll check the file creation rights in
    the folder. As an aside though, why is my program trying to lock it anyway?
    Surely that means no one else will be able to get to it, which is not quite
    the idea. Should I be opening it "no lock" somehow?

    Jerry

    "Chris Barber" <chris@blue-canoe.co.uk.NOSPAM> wrote in message
    news:eTRJADqLEHA.2660@TK2MSFTNGP09.phx.gbl...
    > Usually implies that the user context doesn't have the relevant security
    rights to create the .ldb
    > file in the same folder as the .mdb.
    >
    > Chris.
    >
    > "Jerry Spence" <1@2.com> wrote in message
    news:Xdpkc.37573$Y%6.5157559@wards.force9.net...
    > This problem may cut accross a couple of feeds so I'll try this one first:
    >
    > I have some VB which opens a database file. The enviornment is XP Pro on a
    > domain, and the Access database is on a client and needs to be accessed by
    > other clients.
    >
    > I am opening the database as follows:
    >
    > dbName = "c:\program files\mydatabasefolder\edds.mdb"
    > Set db = OpenDatabase(dbName)
    >
    > I have set up shares and rights to this folder and database. If I am
    > administrator on another PC then all is well. If I am an ordinary user,
    then
    > I get the error message "unable to lock database". If I am an ordinary
    user,
    > but a member of administrators then I still get the same error. It only
    > works if I am actually logged on as administrator.
    >
    > At this point I thought it was something I was not doing in VB in terms of
    > opening the file. However if I come out of my software and go into Access
    on
    > the remote machine as administrator I can open the database OK. If I am an
    > ordinary user (even as member of administrators) I get the same error
    > message.
    >
    > Any ideas?
    >
    > Jerry
    >
    >
    >

  • Next message: Chris Barber: "Re: "unable to lock database""

    Relevant Pages

    • Re: you need permission to perform this action
      ... This posting is provided "AS IS" with no warranties, and confers no rights. ... configure the global permissions for administrators. ... folder, because some folder permissions are changed by design, that's ... I did have the Administrator take ownership of the system32 folder, ...
      (microsoft.public.windows.server.general)
    • Re: activate multiple users
      ... You must provide read/write permissions for the folder for all users who ... need to access the database. ... User will also have to have delete rights as ... The other workstation got the acces to the ...
      (microsoft.public.access.security)
    • Re: Network Folder Permissions
      ... database is used by mulitple users with full access to the shared ... rights on the shared folder. ... changing his shared folder permissions? ... The user in question is in a group that has read-only rights. ...
      (microsoft.public.access.security)
    • Re: RUNAS when a user is just in the user group
      ... Login as a local administrator or user with admin rights that you will use then to run-as explorer. ... The open Explorer goto Tools - Folder Options - View and select 'Launch folder windows in a seperate process'. ...
      (microsoft.public.windowsxp.general)
    • Re: "unable to lock database"
      ... Usually implies that the user context doesn't have the relevant security rights to create the .ldb ... I have some VB which opens a database file. ... I have set up shares and rights to this folder and database. ... works if I am actually logged on as administrator. ...
      (microsoft.public.vb.database)