If you set up Access User Level Security (ULS) *correctly*
you should not mess up any other Access applications on your
machine or any other user workstations. The key to this process
is creating your own workgroup file and securing your database
with that MDW file. Do not mess with the default system.mdw
that Access uses, otherwise you really are going to cause problems.
You and everyone else will start the secured database application
through a desktop shortcut that tells Access which file you want
to open and *which* workgroup file you want to use. This way,
no other applications are affected and everyone can still make and
modify Access databases.
ULS is a difficult process to set up the first couple of times so
I highly recommend practicing on dummy databases until you
are really comfortable with the process. I would also recommend
that you read all of the ULS information I have accumulated here:
http://www.ltcomputerdesigns.com/JCR....html#Security
Good luck,
--
Jeff Conrad
Access Junkie
Bend, Oregon
"mar10" wrote in message:
news:11*********************@f14g2000cwb.googlegro ups.com...
I am creating a database in Access 2002 for a small firm that would
like security on the tables. They want some employees to have write
access only to tables, while others read-only.
I have not done anything with security since way back in version '97.
I'm reading some white papers I've found to gain knowledge of
current security issues.
My question is, can I create security problems with other access
programs I have created as I create users and groups for this new
program? I have a number of small programs I've done for others and
would hate to see that somewhere along the line users or groups pass on
to their databases.
I would not be opening any of the other databases and applying any
security - I just didn't want to fool around with this too much if
I end up causing myself problems in other databases.
If anyone has any links to good sites regarding security for access
2002 that would be helpful as well
Thanks for any insite.
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----