2003 or 2007 Security

[BrookieOU]

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?

 

[Chris O'C via AccessMonster.com]

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