Computing.Net > Forums > Database > Prevent Users from Editing Access

Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free!

Prevent Users from Editing Access

Reply to Message Icon

Original Message
Name: mk1409
Date: September 24, 2008 at 06:29:38 Pacific
Subject: Prevent Users from Editing Access
OS: Server 2003
CPU/Ram: Xeon
Manufacturer/Model: Dell
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?


Report Offensive Message For Removal


Response Number 1
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


Report Offensive Follow Up For Removal







Use following form to reply to current message:

Not Logged In!

You will not be able to post.

Register | Login
   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: Prevent Users from Editing Access

Comments:



Results for: Prevent Users from Editing Access

Access 03/XP DB
    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...
www.computing.net/answers/dbase/access-03xp-db/386.html

create a table from a file
    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...
www.computing.net/answers/dbase/create-a-table-from-a-file/249.html

MySQL Select multiple tables
    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. ...
www.computing.net/answers/dbase/mysql-select-multiple-tables/158.html






Which MP3 player do you have?

iPod/iPhone
Zune
Something Else
None


View Results

Poll Finishes In 4 Days.
Discuss in The Lounge
Poll History






Data Recovery Software