Help Needed! How to protect Excel / Access Data on network?

[jomarrod]

We have a network and share a database (one in Access and one in Excel). The database needs to be updated daily by all users from different PCs.

The question is: How do I prevent other users from editing the database?... I just want to allow them to ADD information but NOT to modify the existing one. I need to be the only one who can correct/modify anything.

Is it possible? How?

Thanks a lot!

 

[drkhelmt]

I would just change the security permissions in windows for that directory to restrict the users to read-only access. I have a Purchase Order database that I need read and write access, but want everybody else to be able to read but not write to and that is now I accomplish this. If you need help on this, I think a windows forum would be a better place.

Hope this gets you closer to the solution.

Andrew
a.k.a. Dark Helmet

"What's the matter Colonel Sandurz? Chicken?