Protecting a Database

[hrbsh97]

I have a database of personnel I designed and because of the confidential
information in the database I would like to protect it. The people at my
company who would like to have access have asked that I put it on our network
on the "shared" drive. I am reluctant to do that because everyone at the
company has access to the shared drive and if they were just browsing around
they easily could find it.

What is the simplest way to protect this database? .. is there a way to just
password protect a folder in Windows? ..

I appreciate any & all help from the experts here

 

[George]

Dear,

The simplier way is to set a passoword (on open) of your database - Tools -
Security - Set Database password (first you must open the database in
Exlusive mode). Although this is not a good idea (can be cracked easily),
depending on the degree of security you need.

The best way is to set the Users and Group Permissions (the most complex but
the most secure one).

Hope I helped.

GeorgeCY

Ο χÏήστης "hrbsh97" έγγÏαψε:

 

[John W. Vinson]

I have a database of personnel I designed and because of the confidential
information in the database I would like to protect it. The people at my
company who would like to have access have asked that I put it on our network
on the "shared" drive. I am reluctant to do that because everyone at the
company has access to the shared drive and if they were just browsing around
they easily could find it.

What is the simplest way to protect this database? .. is there a way to just
password protect a folder in Windows? ..

I appreciate any & all help from the experts here

It somewhat depends on your version of Access. If you have A2003 or earlier
you can implement Access workgroup security. Download the Microsoft Access
2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Print it out. Read it, carefully and thoroughly. Get a good night's sleep;
read it AGAIN, even more carefully! Follow its steps *precisely*. IT's easy to
do security wrong.

Even then, it can be broken by the determined expert.

You can password protect a database. It would take five minutes max to find a
password crack on the internet, and two minutes more to uncover the password.
It's as secure as a cheap bicycle lock.

If you really need good security, put the tables in SQL/Server with good
passwords and proper permissions (consult someone who's *good* at SQL
security), and use Access as a frontend to the SQL tables.

 

[Dale Fye]

While it is nice to believe that no one you work with would compromise
confidential personal information, it only takes one. Strongly recommend
moving your data to SQL Server (the express version is free).

Dale