I'm very, very new to Access and have recently inherited a database.  I would
like to be sole administrator but give people 'read only' access.  Is it
possible to duplicate the database and link the two?  This way I can work on
the database and the 'read only' copy will update automatically.  Many people
will be viewing this document.

Or is there another way?

Thanks in advance.

Split your database into a frontend component (forms, queries,
reports, etc) and a backend component (tables only). The backend
belongs on a shared folder on your network server, while each
workstation should have its own copy of the frontend.

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

Once you have split the database, you will want a method to
automatically distribute any modifications to the various
workstations. Many people use:

http://www.granite.ab.ca/access/autofe.htm


Then apply user-level security to the backend. If you restrict the
Users group to read-only permission, then all your everyday users will
be able to read the data without being required to login. You, as the
developer, will need to log onto Access with the proper credentials in
order to modify the data.

Access user security is not to be taken lightly, so read very
carefully and thoroughly, practice on a COPY of your database, and
don't skip any steps in the process.

Here are a number of links about security:

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Security

There is no "update automatically" required -- everybody will use
exactly the same data at exactly the same time.


On Tue, 24 Oct 2006 22:04:07 GMT, "Karen via AccessMonster.com"
<u5657@uwe> wrote:

--
jackmacMACdon***@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Password for CurrentUser()
special permissions on database
Adding new users to an Access 2002 DB
How to remove Security from Access 2002
Network ID ans user level security