Access Security Wizard

[tmcneil]

I have a database of leases that I would like to secure, but I am afraid that my MS Press book does not give me enough explanation as to how to set this up. I would like to add two groups or users, one that has read only access and the other has read/write access. I've tried to play around with the workgroup info file, but I am clueless. How do I add users to the file so they can logon using a password? All I can do is logon as admin or myself, no matter how many users I add to a secured database.

Could anyone give me some help on this?

 

[Francescina]

Have a look at the MS Knowledgebase. There is a so-called "security whitepaper" that explains clearly the necessary steps to get a working security system (no so easy as it seems).

 

[tmcneil]

I've been looking at it at and it is very helpful. I have a front-end/back-end solution that has to be synched up with the same wif file. I can easily get the user to login to the back-end directly with the correct permissions, but still not the front-end.

The Knowlegebase, Ch. 14 recommends to give the user the Modify Permissions capability. However, it will give my read-only users the capability to update and delete data. I do not want that for the read-only group. How can I work around this and the ability to get the user to login to the front-end easily?