Multi User Database- both people change info

M

MJC

We are trying to set up our Access 2000 on a network where everyone can see
the database (this is already in place) but where only 2 people can get on
the database and change information. How do we do this?
 
J

Jeff Boyce

?You want everyone to see it, but only 2 to be able to add/edit data?

You'll need to work out some form of security. The learning curve on using
the built-in Access security model is fairly steep, so you'll want to
consider alternate approaches.

Can you distribute one version of the front-end to the 2 super-users, and a
different version to everyone else? If so, you could look into ways to make
the data coming into the "other" version not be updateable ... one way would
be to base forms on queries that are Totals queries. Since Totals queries
are aggregating, they aren't updateable, as far as I know.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top