Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Microsoft Access 2007

  • 19-01-2010 5:05pm
    #1
    Closed Accounts Posts: 5


    Hi,
    I have various forms, queries, reports on a database in work.
    I want to make it so i have exclusive rights to read/write in the database & the rest of the office have read only rights.
    My aim is merely to guard against accidental modifications to the data.
    The application runs on a company´s local network and I do not expect maliciuos attacks on the database.
    Can someone simplify how to do this? I've Googled it but way over my head!


Comments

  • Registered Users, Registered Users 2 Posts: 598 ✭✭✭DannyBuoy


    In 2003 and earlier versions you used to be able to create users with passwords to log into the database, different users would have different permissions. User could just have read access to the data, and Admin could have full access. It was in Tools - Security Menu.
    Not sure if 2007 has it but surely has something similiar.


Advertisement