Re: Folder security set up

mscertified wrote:
What is the best way to set up folder security for Access databases.
Do we need only give full rights to the .LDB file and read-only on
the .MDB and .MDE. We are not using user-level security. Is any of
this affected if we use data access pages?

If your intention is for all users to have read only rights then you can just
make the MDB and folder be read only for all users. In that case no LDB file is
ever created.

However; you cannot use network permissions on the file or folder if you only
want SOME users to be read only and others to have edit rights (at least not
very well). Once a read only user is first to open the file and no LDB file is
created then all other subsequent users are forced to read only specifically
because no LDB file exists.

If a user with edit rights opens the file first then all read only users are
locked out entirely because having them open the file would require an edit to
the LDB file, something they won't have the permissions to do.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Running an Access macro from a VB.NETprogram
    ... create a ldb file. ... If your Access mdb is ... My program opens Access to try to do this.. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Sharepoint with Access
    ... Although you can enable .mdb files you shouldn't. ... Access created an ldb file in the same ... If more than one person opens the mdb, ... >> If Sharepoint works with Office 2003 then why can I not upload an Access ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Access database placed in a state...
    ... the back end folder does not require delete rights -- ... it will run just fine without it, though the LDB file will never be ... The usual reason for doing this is to prevent users from ... someone with delete permissions can take care of it. ...
    (microsoft.public.access.tablesdbdesign)
  • RE: LBD File
    ... Well, maybe not you, but your database is. ... The ldb file is created by an mdb when a user opens it. ...
    (microsoft.public.access.formscoding)
  • Re: Error 500
    ... I've added the script I'm ... An access database requires that everyone have full control of the ... the file, last user out deleles it, if the .ldb file can not be created the ... This posting is provided “AS IS” with no warranties, and confers no rights. ...
    (microsoft.public.inetserver.iis.security)
Loading