User rights

[astarbyfar]

Has anyone got an idea on how to issue user rights i.e. one person can write to a certain table whilst another can only read the same table. Ive had a good search but unable to find anything! If anyone has a good thread or website I would be most grateful!

 

[Pat Hartman]

Do a search on the MS knowledgebase for "security FAQ". You will also find many posts here on the subject. However, Jet security is not intuitive and it is very easy to lock yourself out of your database so before you start, make sure that you have more than one safe backup and also have completely read and UNDERSTOOD the security FAQ. You need to follow its directions explicitly.