password protection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kpopp1955 - 28 Jul 2005 20:27 GMT

does anyone know of a way to protect a database by having a user name AND a
password required to open the database? I work for a medical clinic that has
a secured network. All employees have a unique user ID that they use to
access either the network. Some of our PC's have a multi-user ID since many
different staff work on them and then they use their unique ID to access
different programs.

Reply to this Message

Rick B - 28 Jul 2005 21:47 GMT

Yes, that is called user-level security.

It is not easy to set up the first time.

You need to read and reread the following links, make at least one backup of
your databse, then dig in.

Make sure to follow EVERY STEP in ORDER.

Security FAQ

http://support.microsoft.com/?id=207793

The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555

Joan Wild:

www.jmwild.com/AccessSecurity.htm

Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm

Signature

Rick B

--
Rick B

> does anyone know of a way to protect a database by having a user name AND a
> password required to open the database? I work for a medical clinic that has
> a secured network. All employees have a unique user ID that they use to
> access either the network. Some of our PC's have a multi-user ID since many
> different staff work on them and then they use their unique ID to access
> different programs.

Reply to this Message

TC - 29 Jul 2005 04:16 GMT

Is this previous question relevant?

> I've created a database in Access 2000 that has sensitive
> information related to patient healthcare. Our corporate
[quoted text clipped - 4 lines]
> security meet the specification standards set forth by
> HIPAA.

I answered that question, previously, by telling the person that Access
security can (unfortunately) be cracked in various ways using tools
that are in some cases, freely available on the web. "So you will not
have any luck in meeting stringent [security] requirements."

HTH,
TC

Reply to this Message