|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
2003 or 2007 SecurityI have a database that was designed in 2003, but I recently converted it to
2007 (though I still have the backup). I want to be able to set user-level permissions because there will be lower-level data entry people updating information (addresses and etc) that I do not want to be able to access SS#'s, pay rates, etc. After doing bunches of reading (I'm new to database design), I seem to have learned that user-level permissions are not included in 2007. So, I wanted to get an opinion. If I go back to using the 2003 version will I use a bunch of the new functionality (bells and whistles) that is included with 2007? Would it be better to figure out some sort of security system for the 2007 accdb version? User level security isn't secure enough for ssns. Free tools on the internet
allow a user to break security on the file. Put the data in SQL Server for security. Express version is free. Access 2007 supports user level security for all mdbs, but not the new accdb format. No amount of user built security will keep the data secure in a file based db. The built in user level security is much more secure than anything you could build and it's nowhere near good enough to protect ssns. Chris BrookieOU wrote: >I have a database that was designed in 2003, but I recently converted it to >2007 (though I still have the backup). I want to be able to set user-level >permissions because there will be lower-level data entry people updating >information (addresses and etc) that I do not want to be able to access >SS#'s, pay rates, etc. > >After doing bunches of reading (I'm new to database design), I seem to have >learned that user-level permissions are not included in 2007. So, I wanted >to get an opinion. If I go back to using the 2003 version will I use a bunch >of the new functionality (bells and whistles) that is included with 2007? >Would it be better to figure out some sort of security system for the 2007 >accdb version? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200901/1 
Other interesting topics
BE/ FE Question
vba opendatabase readonly record level lock access 2002 can't disable shift key with faq_DisableShiftKeyBypass function ACCDE I'm drawing a blank... Forgotten password and reloading Access Change Ownership of Database Object (?) RWOP and passing variables to a function Maintaining and updating Access 2007 database |
|||||||||||||||||||||||
