I've selected the "ADD ADMIN USER..." option from the advanced tab. It works wonderfully.
Next I created a couple of USER accounts and configured my database with (1=Admin 2=Manager 3=User) in my user table for the Group ID. I assigned these two accounts as USER with a setting of 3. It works very well. The users can only see their respective data and none other.
Lastly, I decided I needed to create a Manager Group ID to allow mgt. into the system. I want their setttings to be identical to the ADMIN account, with the exception of being able to delete. I was able to create their account, (2) however, they can not view all of the user records. I have the security set to "Users can only view and edit their data." How can I get around this for the Manager account?
Build 4.1 (Trial) and Access 2k
-Steve
