Access 2007 user level security

[sstasiak]

As I'm sure many of you know, Access '07 no longer supports user level security.

My question to you all is, how do you secure your DB's in '07? I just built a DB that stores patient data, and it needs to have some type of user authentication to gain access to it.

I know I can assign a general password to it, but I need each user to have their own username and password.

 

[Dennisk]

I work in the healthservice and workgroup security is mandatory. However our DB's are 97-2003. If you design your own login form it will be extremely difficult to protect. The last db I was given with are well designed user login took all of two minutes to gain access to.

I suspose the thinking is, well you have to logon to your PC either onto a network or if the PC is standalone then a user account so that provides defence. Don't forget Access projects do not use workgroup protection either as the security is provided by SQL server.

 

[Joe8915]

just went threw what you are going threw. Try this

Create a desktop shortcut with the following in the target:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

"path to msaccess.exe" is the path to the 2007 version of msaccess.exe
"path to mdb" is the path to the secured mdb
"path to mdw" is the path to the secure mdw on the network