Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Read only access (2000)

    I have an access database that sits on a windows 2000 network. I want one administrator to be able to input data but many other users to be able to view data, forms and reports but not change it.
    How can I do this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Read only access (2000)

    For a real solution, you need Access security. If you do a search for "Access security" (as a phrase), you'll find lots of information.

    Microsoft has some useful downloads:
    ACC2000: Microsoft Access Security Manager Add-In Available in Download Center
    ACC: Microsoft Access Security FAQ Available in Download Center

    If you just want to prevent ordinary users from accidentally editing data, you might use a simple (but basically insecure) solution:
    Put the tables in a backend database.
    Create two frontend databases with links to the tables in the backend:
    <UL><LI>One for the administrator in which all data are editable.
    <LI>One for the other users in which all forms have their RecordsetType set to Snapshot. Set Startup options to prevent access to the Database window etc.[/list]I want to stress that this is only meant for an environment where you trust all users, and only want to prevent them from adding, modifying or deleting data by accident. It is by no means a real protection.

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Wirral, Merseyside, Merseyside, England
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read only access (2000)

    I would be worried about the term 'Many' users. MS Access is not very robust when many users try to access the data simultaneously.

    You may wish to look into run time versions.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Read only access (2000)

    But first you need to define "many" and indicate whether those are simultaneous users.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •