How to best maintenance?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mary A Perez - 11 Jul 2005 15:08 GMT

I have a database that I'm building for my department & another to use.

Currently, I have this database saved to my own "C" drive as well as the
"groups" drive. The users would prefer a desktop icon Vs finding the path,
etc.

How can I do this with only myself being the administrator, & the users only
having "read only" access?

Thank you

Reply to this Message

Rick B - 11 Jul 2005 15:35 GMT

Have you set up UserLevel Security so each user is acked to log in?

You should place the database and the workgroup file on the shared drive.
You should build a shortcut on their desktop that points to the file and the
required workgroup file.

Note: Security is not trivial. Make a backup or two and follow all the
steps in order. When you finish, test it by joining the default workgroup
(system.mdw) and verify that you cannot get into the file using that
workgroup and signing in as ADMIN.

Read the following links carefully before you begin.

Good Luck,

Signature

Rick B

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

> I have a database that I'm building for my department & another to use.
>
[quoted text clipped - 6 lines]
>
> Thank you

Reply to this Message

Nikos Yannacopoulos - 12 Jul 2005 08:11 GMT

Or, you could cut some corners by asking your network admin to create a
special folder for the purpose on the shared drive, on which only you
have full rights, while everyone else has read only.

Mind you, this will only guarantee that nobody else will
add/change/delete data; user level security can do much more, like
selective access even for display at user / user group level etc.

HTH,
Nikos

Reply to this Message