Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Prevent Users from Editing Access

Comment:

I have an access database stored on a server with multiple users accessing to search. Is there a way to lock the layout of the database so that users can not save changes to the layout or format of it, but can still search and use the database as normal?

Name: Jennifer SUMN
Date: September 25, 2008 at 13:43:58 Pacific

Reply:

What exactly is "normal?" Do you want to the users to be able to only work with the database without entering any new data? Search Help for User and Group Permissions. That's what you need to set. It's pretty detailed and can be complicated if not managed properly. "So won’t you give this man his wings What a shame To have to beg you to see We’re not all the same What a shame" - Shinedown

0

Hidden ODBC DSN although ...

Script to check database ...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi, I have a user trying to print reports from a DB, but she receives a debugging error everytime. Essentially, the stand-alone (no SQL connection required) DB is a shortcut from a mapped drive on the...

Summary: Can someone tell me why the following is not working? $query = file_get_contents("import_data.sql"); echo ($query); $result=mysql_query($query); import_data.sql contains the mySql commands to ad...

Summary: Hi FishMonger, Thanks for the links. I have to admit I am not the most experienced with databases and have only recently started PHP web development linked to MySQL databases due to a change in jobs. ...