Multi User Database- both people change info

[Guest]

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?

 

[Joseph Meehan]

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?

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

Access 2007 as it doesn't support user-level security.

 

[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