Re: Linked Server to Access DB Security

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi AG,
Thank you for your response.

I looked through your process monitor traces. I found that for those failed
traces, the first ACCESS DENIED error was on winemaster.mdb and the second
was on winemaster.ldb. After compared with those successful ones, I think
that the first ACCESS DENIED error on the winemaster.mdb should be
misleading and the real tricker should be .ldb file. When SQL Server tried
to get a Generic Read/Writer operation to the file, the ACCESS DENIED is
raised.

As I mentioned before, no matter SELECT/INSERT/UPDATE/DELETE to your access
database, if you are trying to access the .mdf file, Access will try to
read/write lock information in the .ldb file. Since the .ldb file may be
not there when you first time access the .mdb file, it requires the current
user have READ/WRITE permission on the upper folder; If you just need read
permission to your Access database, I recommend that you assign Read and
Write permission at the folder level but only give Read permission on your
Access database.

Thank you!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================


.

Relevant Pages

  • 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)
  • Re: 2nd User Cant Open db on LAN
    ... 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. ... been a sudden surge of work here, so it may be a few days ... so headway doesn't come easy. ...
    (microsoft.public.access.security)