Results 1 to 3 of 3
  1. #1
    Tommy1005 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    3

    Allow some users to edit, and other to only view?

    Hey I'm making a database for a school project, and basically when you open up the database file I want it to ask for a username and password. And some people get full control over it (they can edit text and numbers, etc) and others can only view it.

    For example if I login in as "Admin" I want to be able to edit everything, but if I login as "John" I want to make it so you can only view stuff.



    While we are on the security topic.. is there anyways I can restrict the number of times someone can search the database? I don't want someone searching like 100 times and just collecting info. So if the database gets searched like 20 times in under 5 minutes, can you make it cut them off?

    Help is much appreciated!! Thanks

    Also I've been reading posts and forums about this for a couple hours, but I really havent found any good step by step guides on how to do it.

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    Go to the help menu and search for security. In A2003 there is a section called "Help protect an Access database and its objects with user-level security (MDB)" You should find this or something similar with step-by-step instructions.

    As for searching I think you would have to add a Database Property that got incremented after each search using code but It would have to be user specific.

  3. #3
    sdondeti is offline Novice
    Windows 98/ME Access 2003
    Join Date
    Aug 2009
    Posts
    23
    Please go through the link below step by step from the beginning.
    http://www.databasedev.co.uk/distribute_secure_app.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to disable edit for combo boxes
    By access in forum Forms
    Replies: 3
    Last Post: 06-17-2009, 09:11 AM
  2. Combo-box to select item to edit in Form
    By DHavokD in forum Forms
    Replies: 7
    Last Post: 06-05-2009, 01:39 PM
  3. Click a record to display it for edit
    By mapl in forum Access
    Replies: 0
    Last Post: 11-24-2008, 03:02 PM
  4. Can I edit a record with a subform?
    By bigmax in forum Forms
    Replies: 0
    Last Post: 08-11-2008, 07:55 AM
  5. Most reliable way to edit form data in VBA...?
    By samalter in forum Programming
    Replies: 0
    Last Post: 06-23-2006, 12:39 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums