Lock up Db

[Aurora]

I am using Access 2003
I have just created a Preventative Maintenance Db. The computer this
program will be on is in a area that a lot of people have access to.
Therefore, how can I lock it up, so that no one can get to the fields (the
guts of the program) and make changes? Only one person should be using this
program. Can I lock up the whole database or do I have to lock up each form
and report? Can I make the database password protected? If so what happens
if the operator assigns it a password and then is out sick for a long time.
If I do not know the password, is it possible to override the operator's
password with another password?

Aurora

 

[Cyberwolf]

IF your looking for a way to secure it. I would use the User Level security
wizrd. But, before you do this on the actual database copy it and play with
the copy. Make sure you thoroughly understand how this works before applying
it to the actual database. THis way you as an Administrator will always have
access to it. Also, you might want to split it into a Front-end/Back-end.
This will place all of the table in one db(back-end) and all of the other
info in the fornt-end. This will prevent someone from going in and messing
with the design of the tables.

 

[Jerry Whittle]

Converting the database to an MDE locks up the forms, reports, and a few
other things so that people can't mess with their design. However that does
you no good if you want to protect your tables.

User level security is complex and work to maintain. If you have multiple
users, that would be the way to go; however, for a single user it's overkill.

That leaves securing database with password protection. For all practical
purposes, there is no way to bypass the database password short of buying an
expensive password cracking tool or sending the database away to do it.
Therefore it's extremely important for at least two people to know the
database password. This is a management issue similar to at least two people
having the keys to an important lock. If I were the #2 person, I'd make a
point of testing the password at least once a week.