Re: Protect Database From Accidentally Being Deleted

> Unfortunately, that will have the side effect of making the database
> read-only. Each user must have Delete and Create permission to the

Read only if you don't have CREATE permission.

Delete permission is required to compact the database, and to
delete the ldb file. Deletion of the ldb file is required if
it becomes corrupted, or if database Exclusive Access is
required.

So for a shared database, you can reserve delete permission
for an administrator.

(david)

PS:
The ldb file is created when the first user enters the database,
and deleted when the last user leaves, if permission is allowed.
So after being deleted the first time, the ldb file picks up
whatever permission is assigned to new files

Can you just remove delete permission for the database file?
Yes, but compact will fail, so before and after compacting you
need to reset the permission.



"John Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:e0fjj1luhho3uhrrv5a63fchh0c6t368ck@xxxxxxxxxx
> On Tue, 27 Sep 2005 13:47:01 -0700, Klatuu
> <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
>>You will need to get with your network administrator and have him/her/it
>>set
>>the permissions for the users to not allow deletes in the folder where the
>>mdb is.
>
> Unfortunately, that will have the side effect of making the database
> read-only. Each user must have Delete and Create permission to the
> folder, so that Access can create and then delete the .ldb locking
> file!
>
> John W. Vinson[MVP]


.

Relevant Pages

  • Re: DBEngine.CompactDatabase and Permissions
    ... You need exclusive access to compact a database using Jet. ... admins group or had administer permission to the database. ...
    (microsoft.public.access.security)
  • Re: DBEngine.CompactDatabase and Permissions
    ... You need exclusive access to compact a database using Jet. ... admins group or had administer permission to the database. ...
    (microsoft.public.access.security)
  • Re: DBEngine.CompactDatabase and Permissions
    ... exclusive permission in order to compact a database. ... You still get and need an exclusive lock to do a compact. ... someone opens the backend during the compact? ...
    (microsoft.public.access.security)
  • Re: code access security
    ... Error 1 CREATE ASSEMBLY for assembly 'GmsSqlClr' failed because assembly ... owner has EXTERNAL ACCESS ASSEMBLY permission and the database has the ... make sure the database owner is mapped to the correct login on ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: low permission cannot convert from A97 to A2000/2003
    ... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
    (microsoft.public.access.conversion)
Loading