Interesting. My mind went to, wow she or he is smart and should I have her or him working with me, and what business need isn't being met that this individual feels the need to bypass the regular ops?
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<http://www.rockwellcollins.com/>
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, July 19, 2018 4:52 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Database protection
Hi Bill
Just curious - how could you stop some smart-arse from writing some external code to turn on AllowBypassKey, then opening the database with the shift key?
Best...
Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, 20 July 2018 05:04
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Database protection
Just for clarification...Workgroups (User Level Security) only work for MDB files such as Access 2003 and earlier. They are not available for ACCDB files. From what I understand, MS decided to do away with ULS because it really wasn't that secure. Unfortunately, they didn'! ;t replace it with something new. We developers had to come up! with our own homegrown security that relies heavily on code.
One project I had needed to be converted to an Access 2010 file so I spent a good month writing the code to use Active Directory authentication and then code all forms/reports security based on the username and group. Yes, it's more secure unless someone has shared his username and password to his AD account, but it was a real pain.
Regards,
Bill Mosca
From: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, July 17, 2018 2:09 PM
To: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>
Subject: RE: [MS_AccessPros] Database protection
!
On a more granular level, you can choose Tools/Security/"Workgroup and User Permissions".
This will let you set specific permissions for each table and each user or group. Just make sure you are the admin with full permissions.
This assumes that users need to log in using their username/password.
Gary
At 04:22 PM 7/17/2018, you wrote:
You can put a password on the database I think it is on the file menu?
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
! (520) 239-4808
Liz_ravenwood@beaerospace.com<<mailto:Liz_ravenwood@beaerospace.com%3c> mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com< http://www.rockwellcollins.com/>
From: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com> [ mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, July 17, 2018 12:58 PM
To: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Database protection
I want to know how to prevent anyone to change the design of the table in a database that contains only tables
or how to protect the database without using the programmi! ng codes
thanks in advance
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
------------------------------------
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com<mailto:Liz_Ravenwood@beaerospace.com>>
------------------------------------
------------------------------------
Yahoo Groups Links
--------------------------------------------------------
Gary D. Schwartz Please reply to: gary.schwartz@pobox.com<mailto:gary.schwartz@pobox.com>
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar