Re: back end security

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



"Keith Wilby" <here@xxxxxxxxx> wrote in message
news:45e7ecf3$1_1@xxxxxxxxxxxxxxxxxxxxxxxxx
"Rashid" <Rashid@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F0DC65B1-608D-4E7F-A84D-D1CF4CD5C20C@xxxxxxxxxxxxxxxx
I have a front end/ back end data base in access 2003, I have secured the
front end with password and convert to mde and disable shift bypass key,
my
question is how can I prevent back end from accidental or deliberate
deletion.

Thanks in advance

There are a couple of precautions you can take. First, put the BE in a
hidden folder. Next, set the NT file permissions on the *file* to RWX (ie
NOT delete) - be sure not to do this on the folder since all users need
RWXD permissions to handle the record locking file.

Just be aware that after you compact the BE, you'll need to reset the
permissions on the file, as it will inherit the permissions from the folder.

Securing the backend won't prevent its deletion.

--
Joan Wild
Microsoft Access MVP


.



Relevant Pages

  • Re: Minimum NTFS Permissions - Theres such a thing???
    ... ?2001 Microsoft Corporation. ... HOW TO: Set Minimum NTFS Permissions Required for IIS 5.0 to Work WGID:198 ... " List Folder Contents" ...
    (microsoft.public.inetserver.iis.security)
  • Re: Unable to delete orphaned 1.5 GB System Restore folder
    ... The fact that the tech support is based in India has nothing to do with the ... If so you may want to leave this folder alone. ... down to all children folders because i can set those permissions to ... try deleting from the command line using system by using the AT ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Unable to delete orphaned 1.5 GB System Restore folder
    ... The only computers i fix are my own. ... If so you may want to leave this folder alone. ... it includes all subdirectories with inherited permissions. ... try deleting from the command line using system by using the AT ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Word mail merge data source
    ... "Peter Jamieson" wrote: ... Word on it) then there may be a problem if the folder containing the data ... Word builds a connection string. ... superset of other users' permissions - for example, ...
    (microsoft.public.word.vba.general)
  • RE: no OWA
    ... have the correct permissions was the "inetpub" folder. ... Correct the settings in IIS: ... click to check the "Hide All Microsoft Services" ...
    (microsoft.public.windows.server.sbs)