Re: Protect File from Deletion

"Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in
news:pk_nh.14092$yC5.961@xxxxxxxxxxxxxxxxxxxxxxxxxx:

prototype wrote:
I have an Access database on a network drive and I am worried
about someone accidentally deleting it. Is there a way to protect
the database from being deleted?

Users need fairly full permissions on the folder so the locking
file (LDB) can be properly managed. You can give them delete
perms on the folder but not on your MDB file but you will have to
reset that every time you compact the file.

They don't actually need delete permission on the LDB file -- when
they log off, Access tries to delete it and it fails silently, with
no repercussions.

The only drawback of this (and I've done it in production apps) is
that if corruption develops in the LDB it stays around because it
never gets deleted. One way around this is to give certain users who
are trusted not to delete the file (your managers, maybe; or maybe
not!) by putting them in a user group that has delete permission on
the file. This means that any time one of those users is last one
out of the database, the LDB will be deleted. I've done that with
production apps and it works.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Linked Server to Access DB Security
    ... Setting read/write on the folder and read/deny write on the database files ... user have READ/WRITE permission on the upper folder; ...
    (microsoft.public.sqlserver.server)
  • Re: Operation must use an updateable query.
    ... Folder remains read only. ... > You need to have write permission for the database file/folder. ... >> Operation must use an updateable query. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot write text to the file located in IIS wwwroot director
    ... Right-click the Pets folder, ... Select the ASP.NET account, and add Write permission. ... >> Editing an Access Database with ADO.Net ...
    (microsoft.public.dotnet.languages.vb)
  • Re: No form records are inserted into database
    ... I then create the database and insert the fields corresponded to those field ... the parent folder. ... I also give permission on IIS to have write/read permission for scrip from ... But if your hosting service provides DNS, it might be much easier as I later ...
    (microsoft.public.frontpage.programming)
  • Re: Question for Joan (or anyone with knowledge of security)
    ... > database) and saved it on the C: ... > Should there be an LDB file in the folder where I saved the NEW ... Joan Wild ...
    (microsoft.public.access.security)
Loading