DB security on a shared networked Drive

[Malkavian]

I've created a database on put it on a shared network drive. I have several people who will need to use this database but I dont want some of them to be able to edit the database in anyway.

Ive tried creating individual user accounts for the database but I don't think I'm grasping how the security works.

When on my machine I'm promted for a username and password but when on someone elses machine they can open up the database with full access.

How do i create individual user security accounts on a database I want to share on a network drive?

 

[Len Boorman]

I have a couple of documents associated with Access Security. They are too big to post here but if you PM me with an email address I will sned them direct. Security is a minefield for the unwary

Len B

 

[Malkavian]

Thanks Len, I've sent it.

Anyone else have any input on how to resolve this problem?

- Malk

 

[ghudson]

Search around for your question has been asked and answered in many threads.

 

[Malkavian]

Search around for your question has been asked and answered in many threads.

Some people do not have the freedom to surf forums like others.

I'm forced to use 97' without any patches or upgrades and as a result, I've learned my problem has no solution.

Thanks Len for your help unlike some.

- Malk