Entire Database security

[Jon Gellat via AccessMonster.com]

Hi,

I have made a large database for my company with information about
customers etc. What i need to do is make this database 100% secure. There
are 12 people in my office and i want to put the database on the server and
make sure they need to log into the database (password) to be able to
access it. The server is acessable by our head office up north, therefore i
need to ensure no one can just come into our folder and open up the
database and view what they like. Also i need to make sure the database
cannot be e-mailed or stolen or moved or copied. basically i need it to be
100% secure or as secure as it can be, because the one concern i have had
regarding the database from my head office is the security..and it is the
one thing i am unsure of.

Thanks for your help

 

[Keith]

Hi,

I have made a large database for my company with information about
customers etc. What i need to do is make this database 100% secure. There
are 12 people in my office and i want to put the database on the server
and
make sure they need to log into the database (password) to be able to
access it. The server is acessable by our head office up north, therefore
i
need to ensure no one can just come into our folder and open up the
database and view what they like. Also i need to make sure the database
cannot be e-mailed or stolen or moved or copied. basically i need it to be
100% secure or as secure as it can be, because the one concern i have had
regarding the database from my head office is the security..and it is the
one thing i am unsure of.

You can't make any Access app 100% secure because of the "hacking" utilities
that are commonly available. You also can't prevent anyone with access to
the host folder from copying, e-mailing and the like. If you want 100%
security then go for something like Oracle.

Having said that I think you need to do a risk assessment - how likely is it
that someone with access to your servers will want to defeat Access
user-level security. If you decide that the risk is low then you need to
read and follow the steps in the MS FAQ (link on my web site). There is no
filler in that document, you need to read and understand it *all* and
follow *all* of the instructions. Remember to back up your files first in
case you lock yourself out.

Keith.
www.keithwilby.com

 

[Jon Gellat via AccessMonster.com]

I just ran the user level security wizard, and now that i've gone all
through the wizard and it has finished..i can't now get into my
database..when i click on "enter" on my startup screen it says "Records can
not be read, no read permissions on 'switchboard items'.

I don't knwo what i've done wrong but it doesn't ask me to log in
oranything when i open it..it just takes me to the screen then tells me the
above..now i'm panicing!

 

[Jon Gellat via AccessMonster.com]

Ignore that, just sorted it

 

[Keith]

Ignore that, just sorted it

Good, but there was no need to panic because you'd backed up your files
first, right? )

 

[Rick B]

Jon:

If I were you, I'd try to open the fiel from another PC. Make sure that it
is properly secured and that someone who is not amember of your new
workgroup can't get access to it.