What is the best Security Setup for 9 PCs/Mult Users?

[erinjpd]

Greetings!

I have recently created an Access db for some of my co-workers and need some
direction on the best security setup for use on 9 PCs with multiple users.

My users will be entering data constantly and need to see what others are
entering, as well, but I believe I must have my security settings setup so
that only if a user closes Access and logs in can they see any new data.
Refreshing data in a form does not do it.

Any direction you can provide me would be greatly appreciated!

 

[TC]

You are saying that several users are adding records to the same
database, but when one user looks, he can not see the records that the
other users added?

That would not be a security issue, IMO.

Give us some more details about the database, and the forms that the
users are adding records through. Do those forms have VBA code behind
them? What does that code do? Are you sure that the form does not just
have a filter, which excludes the other users' records from view? Have
you split the database into a so-called "front-end/back-end" structure?

HTH,
TC