READ ONLY ON NETWORK

  • Thread starter Thread starter scoobydo
  • Start date Start date
S

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
 
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
Click to expand...

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