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

Microsoft Access 2007

Options
  • 19-01-2010 6:05pm
    #1
    Reggaetrip
    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

  • Options
    #2
    DannyBuoy
    Registered Users 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