User level security is a pain! But I got it working!
Used security wizard. Created a new project.mdw file. It left an unnecessary systemx.mdw, as a footprint, that I later deleted.
The wizard automatically deleted the Admin user connection to Admins group. It created me (user) as a user and connected me to the admins group (I also added a new password). It remove all the permissions from the users group as I requested. It encrypted my DB. And it created a shortcut on my desktop that links my DB and my new dbw file. Works fine. I did not use the workgroup administor.
My next goal is to reverse the process. You ask me why? I always like to be able to get back to groud zero.
Decrypted by opening exclusive using /excl on the short cut and using the encode/decode command. Added Admin user to Admins group then added run permissions to the users group (IMPORTANT).
Reopen the DB with the system.mdw file. DB opens without password.
Added permissions to the admin user. That worked. Try to add admin permissions to the admins group. (I'm not allowed to change). Is this a known problem? Where is the black magic?
Used security wizard. Created a new project.mdw file. It left an unnecessary systemx.mdw, as a footprint, that I later deleted.
The wizard automatically deleted the Admin user connection to Admins group. It created me (user) as a user and connected me to the admins group (I also added a new password). It remove all the permissions from the users group as I requested. It encrypted my DB. And it created a shortcut on my desktop that links my DB and my new dbw file. Works fine. I did not use the workgroup administor.
My next goal is to reverse the process. You ask me why? I always like to be able to get back to groud zero.
Decrypted by opening exclusive using /excl on the short cut and using the encode/decode command. Added Admin user to Admins group then added run permissions to the users group (IMPORTANT).
Reopen the DB with the system.mdw file. DB opens without password.
Added permissions to the admin user. That worked. Try to add admin permissions to the admins group. (I'm not allowed to change). Is this a known problem? Where is the black magic?