Prevent Deletion of Database

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

I created a access file and would like to prevent
accidental/deliberate deletion of the file. Will setting
up security groups allow only admin to delete the file?
Or, can I get this protection on the file though other
means within Windows.
Thanks for the help. The data is becoming valuable and I'd
like to prevent mishaps.
 
This is a filesystem problem, not an Access security problem.
The safest way is to take regular backup copies of the file. Its almost
impossible to prevent a user deleting a file, and at the same time allow
them the read/write access needed for data entry. But you can store the
backup copies in a folder to which no-one else has filesystem read/write
permissions.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Hi

Within the context of your question, there is security for the physical file
itself (i.e. the Access MDB file) and then there is security for the various
objects within the Access MDB file.

- Security for the physical file (the MDB file) is governed by the Operating
System. Are you on a single user machine? Are you on a network? Whether or
not a user can delete the MDB file depends on rights and privileges assigned
by the network systems administrator (i.e. operating system level security).

- Security for the various objects within the Access MDB file (i.e. forms,
reports, queries, tables, records, etc.) is governed by MS Access Security.
Whether or not a user can delete a form, query, tables, etc. depends on
rights and privileges assigned by the database administrator within MS
Access (i.e. application level security)

So to answer your question:
- Setting up security groups within Access is an application level security
function. File deletion is an operating system level security function. So
setting up groups in Access would not prevent/allow users to delete the MDB
file itself.
- File deletion protection would have to be done at the operating system
level. I would need more information on what operating system environment
you are using. A network? Peer to peer? Single user?

Last but not least, there is always the safety net of a good old "backup
program". If you backup nightly, the most you can lose is a day's work.
Routine backups not only protects you against accidental deletion, it also
allows you to revert back from possible data corruption, some of which are
irreparable.


HTH
Immanuel
 
You can't really prevent this as users need full permissions to the folder
where the backend is.

Your best bet is to make and test regular backups. You can also hide the
backend folder...
\\server\share$ rather than \\server\share
That will hide it in Windows Explorer, however if they know the path they
can still get to it, if determined.
 
Thanks,
I have 8 users connecting to a Win2000 Pro Terminal Server
environment and have nightly tape backups. I now realize
that I need to restrict means of deleting files
through "group" policies. I need to setup passwords and
user restriction within MS Access to prevent deletion of
table, reports, queries...etc. That's what I needed to
know. I just didnt know where to start.

It'd be nice to just right-click on a file and have
options of password protecting the deletion of that
specific file.

Much appreciated...
 
Sounds like you are on the right track, but to save confusing us, please get
your terminology correct.
Access objects like tables, queries, forms and reports are not 'files'. All
these objects are part of one 'file' - the database. So when you talk about
'files' people assume you mean the database file(s), which are a filesystem
object, and you have to secure them using the methods applicable to files,
eg permissions on folders etc. When you talk about Access tables etc, then
you can prevent/allow users doing things to those objects with Access
security.

See the difference ?

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top