Security Permissions

[Tango524]

I set up permissions to users for forms, tables, etc, and I also have a password to my access database. The users that have these permissions can get into the database and update, add, or delete data in the forms and it will of course save to the tables. A person who did not have permissions but knew the password could get into the database and key in info to the forms, but it would NOT be saved to the tables. I was wondering if there could be an error message for users who don't have permission to the database or to actually PREVENT them from keying in data to the forms. Any help would be great!
Thanks!

 

[dannyocean]

I would get rid of the password and go to user level security. This will give you more control and will keep out unwanted users.

Here is an explination of how to set it up.

1. Set up a mdw file for your db. Use the help instructions in Access for a Workgroup file.

2. After you create the new mdw make sure to rejoin the system.mdw file for your copy of access.

3. Create a shortcut in the target line you will need to fix the sytax. Here is a copyu of one of mine.
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" V:\Puball\UM\Discharg.mdb/wrkgrp V:\Puball\Um\Discharg.mdw

V is the network drive. DOn't go lower than two folder levels. I had trouble and that was an issue.

The shortcut launches access then your db and the associated workgroup.

Once you get the shortcut working. Go into tools, security, user and group accounts. Add you users. Then distribute the shortcut. Make sure to have a working copy of the shortcut on the network so you can retrive it for distribution.

I answred some other questions on this topic on thread 181-355840.

Let me know if you have any questions.

Danny