[DiGiTY]

I have a Access 2002 database that needs design mode disabled or restricted from certain users, essentially only allowing them to input data... how do I accomplish this???

TIA

[OBP]

Secure the database using the Security Wizard and then set up the user groups for those who can and can't use design functions.

[DiGiTY]

i've been trying the wizard and it's giving the results I want at all. when I complete the wizard, restart Access and then re-open the file, it just opens... nothing indicating user privileges.

all I wanna do is have a full permissions user and a user who enters data. i kinda got what i wanted without using the wizard by simply adding a user and creating passwords with "User and Groups Accounts..." and defining the security scope with "User and Groups Permissions...". But the problem is it'll ONLY ask for the user/pass on the machine I opened and set the permissions on. I open it from another computer on the network and it just opens as if no permissions were set. the db file is on a shared drive.

any ideas how to get it to use the same security settings on all/any computer it's opened from???

[OBP]

DigiTY, having secured the database the only way that users should be able to open it is by joining the secure workgroup. So if you have secured it and then created the user groups the only thing possible is that the database has lost it's security.
Creating the user groups without securing the database does not work.
I have secured many databases and the only time they have ever lost their securtiy is during a zip/un-zip process and only on very few occasions.
So the way it should work is this.
Secure the database, noting the Secure .MDW file that is created and Desktop Shortcut.
Put that .MDW file on the server in the same folder with the database, if it isn't aleady in that folder.
Create the user Groups.
Give each user a copy of the desktop shortcut (with modified properties if you had to move the .MDW file) The shortcut points to where Access is stored, where the database is stored, where the .MDW file is stored.
The .MDW file holds the permissions of those that can use the database with their security clearance levels.
Create a special Group that is given all Admin rights and then remove them all from the Admin group, so anyone logging in as Admin can't change the database.