Creating share access as read only??? 1

[pfenton]

I've created a database which can be 'doctored' by me and 'Frank'. I want to create an exact copy on the server, except info cannot be added, edited or deleted by others.<br>Do I have to make changes in 'Users / Groups' thingies or what happens?<br><br>Administor: me('Paul') and 'Frank'<br>Read-only: others: 'Pat', 'Dermot', 'Darren',<br>But I don't want to password protect the database, how can I set this up?

 

[3587]

You can build a database with just Forms showing the information you want the other users to see. Then put this database on your server and link only the tables needed for your Forms. Then use the Form's properties &quot;Allow Edits, Allow Deleations, Allow Additions&quot; and set them all to NO.

 

[IAmStuck]

A really basic solution which might do what you want (I looked all around before discovering this simple answer) is to change the file properties to read-only.&nbsp;&nbsp;You do this by closing the application and going into File Manager / Windows Explorer and right-clicking on the file name of your database.&nbsp;&nbsp;Select Properties from the pop-up window and check &quot;read-only.&quot;

 

[elizabeth]

Don't bother with a copy of the database, you can easily do this with Access security. Assuming you've already used the Security Wizard to set yourself and Frank as admins, and have removed the Admin User from the Admin Group:<br><br>1. Create a Group called &quot;ReadOnly&quot;. <br>2. Create new Users Pat, Dermot, and Darren.<br>3. Assign them to the ReadOnly Group.<br>4. Assign read only permissions for all objects to the ReadOnly group.<br>5. Remove all (including read) permissions from the User group.

 

[pfenton]

How do I remove the Admin user from the Admin group. It keeps telling me that there needs to be at least one user even though I've added several names etc.?

 

[elizabeth]

I never have had this happen but maybe t's because I do things in a certain order. Here's what I'd try:<br><br>If you have added yourself to the Admin group, exit Access and then open the database again under your new userid. Once in the database, change your password. Exit and enter the db again using your new ID and password. Then remove the Admin user from the Admin group (leaving it in the User Group of course). At that point I would probably exit the database, enter it again as the admin user, and change the admin user's password (as an admin you can always reset it later to blank if you like).

 

[elizabeth]

BTW, you also need to make yourself or another admin the owner of all db objects. If the admin user is left as the owner of all the db objects, it will have all permissions, which will override group permissions. The easiest ways to change the owner of the database is to open access under your userid as an admin, create a new db and import all objects. this is the same thing that happens ifyou use the security wizard.

 

[DreewToo]

<br>If you first add yourself to the Admin group, the original admin user can be removed.&nbsp;&nbsp;<br><br><br>I am trying to construct something similar, where a reporting front-end is attached to a database on the network, and users can select which report/how to publish from a variety of databases.&nbsp;&nbsp;I'd rather not force them to enter a username and password on each access, so I'm considering setting them up to open the remote report, choose the criteria of the report from combo boxes, receive the report, and then close the remote database when the report is closed.&nbsp;&nbsp;So far this seems reasonable, and would prevent users from playing around with the objects.&nbsp;&nbsp;I'd prefer another means, since I could picture a number of ways around the scenario where I could get to the database window, but I haven't tackled them yet.<br><br><br>

 

[pfenton]

I got around the problem by making the folder, where the database was stored on the server, write only to myself and Frank.<br>This way no-one else can mess it up except me and him!!<br><br>Thanks for all the help, anyway!