Access 1977 - Security

  • Thread starter Thread starter Karen via AccessMonster.com
  • Start date Start date
K

Karen via AccessMonster.com

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.
 
Back
Top