READ ONLY ON NETWORK

[scoobydo]

Hi I am fairley new to Access and urgently need some help. I have built
a database comprising of various queries, forms and reports which is
stored on a network drive. What I would like to do is have the database
open to everyone as read only, however letting certain users only able
to edit i.e password authorised. Any replies please note an idiots
guide please not an access expert.

thanks Paul

 

[Michel Walsh]

Hi,


The security as supplied by Tools | User and Group...

The knowledge database has a lot of documentation
(http://support.microsoft.com/search/?adv=1), including
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q165009


Hoping it may help,
Vanderghast, Access MVP

 

[jacksonmacd]

You will need to do a couple things. First, you must split your
database into two components: frontend and backend. The backend
contains only the tables, and is mounted on the server. The frontend
contains everything else, and an individual copy is mounted on each
workstation. Find additional information at

http://www.granite.ab.ca/access/splitapp/index.htm

Second: what you want to apply for security is called User Level
Security (ULS). It's not simple to implement and easy to make a
mistake. Find my version of the steps you need to follow in the
website in my signature. It also contains links to other similar
documents.

Hi I am fairley new to Access and urgently need some help. I have built
a database comprising of various queries, forms and reports which is
stored on a network drive. What I would like to do is have the database
open to everyone as read only, however letting certain users only able
to edit i.e password authorised. Any replies please note an idiots
guide please not an access expert.

thanks Paul

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security