Re: 2nd User Can't Open db on LAN

But it's the create permission that is needed. This is so the users can create the associated ldb file. If the first person in doesn't have create permission, they will open the mdb exclusively.

--
Joan Wild
Microsoft Access MVP
"croy" <croy@xxxxxxxxxxx> wrote in message news:fv3do3l9ifpqembfef1vmjfml5mbv0getl@xxxxxxxxxx
On Wed, 9 Jan 2008 14:39:11 -0500, "Joan Wild"
<jwild@xxxxxxxxxxxxxxxx> wrote:

All users need read/write/create Windows permissions on the folder where the backend is located. This is so the associated ldb file can be created.


Thanks for the reply, Joan.

Both of these users have RW permissions on that directory
and all the files in it.

I'm looking into the server's security setup, but there has
been a sudden surge of work here, so it may be a few days
before I make any headway. Plus, I'm not a network
engineer, so headway doesn't come easy. I'll probably be
back with better info and more questions next week.

--
croy
.

Relevant Pages

  • Re: Linked Server to Access DB Security
    ... I looked through your process monitor traces. ... the first ACCESS DENIED error was on winemaster.mdb and the second ... misleading and the real tricker should be .ldb file. ... user have READ/WRITE permission on the upper folder; ...
    (microsoft.public.sqlserver.server)
  • Could not Lock File error
    ... >I'm trying to share an access database with an entire ... >modifying this file with FULL PERMISSION on the parent ... >or not AND ONLY allowing one person to modify it's ... It's called an .LDB file, ...
    (microsoft.public.access.security)
  • Re: Contention/Locking Problem on Network
    ... Do all users have permission to create files in the BE folder? ... person to open the db needs to create the .ldb file or the db can't be ... >>> Hi Klatuu ...
    (microsoft.public.access.modulesdaovba)
  • Re: Protect Database From Accidentally Being Deleted
    ... Read only if you don't have CREATE permission. ... Delete permission is required to compact the database, ... delete the ldb file. ... Yes, but compact will fail, so before and after compacting you ...
    (microsoft.public.access.formscoding)