By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,679 Members | 2,331 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,679 IT Pros & Developers. It's quick & easy.

Access 2002 security

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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 =----
Nov 13 '05 #2

P: n/a
Thanks for the info and link - I now feel at least a little more secure
about playing around with security -

Nov 13 '05 #3

P: n/a
"mar10"wrote in message:
news:11**********************@o13g2000cwo.googlegr oups.com...
Thanks for the info and link - I now feel at least a little more secure
about playing around with security -


You can do it, but just give yourself some time.
You will not "get it" in an hour or two.
It takes time and patience, but when you really
have ULS mastered, it becomes an incredible
tool in your Access arsenal.

Good luck with your project,
--
Jeff Conrad
Access Junkie
Bend, Oregon

----== 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 =----
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.