Access Project Security

[TheWebDataGuy]

I am developing a database solution using Access Project. My backend DB is in SQL Server.

I have questions about securing the DB. I would like to hide all the tables when the user open the DB using Access Project, so that they donot make any design changes. So in the object explorer window I want to display everything except the Tables. But I want users to be able to SELECT, UPDATE, INSERT and DELETE records from the database using Forms. The again I don not want to them to delete the whole bu running a delete query by mistake.

Sounds like complicated permissions.

Is this possible?

Thanks!

 

[dannyocean]

I recommend setting up ueser level security. This will allow you to give right to specific items in your db. Here are the basics of setting up security. User level security also helps to aviod write errors your users may have.

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.

This will allow all users global access to the db, but will fix your Write errors.

Let me know if you have further questions.