Results 1 to 2 of 2
  1. #1
    Dannat is offline Novice
    Windows 7 32bit Access 2002
    Join Date
    Jan 2012
    Posts
    18

    Freeze or Lock data after querried

    Hi,
    I was wondering how I might be able to lock the data within teh querry so the user can see the info but not edit it. I need the first 3 results frozen and the others open to edit. Here is what my coding looks like:

    SELECT register.first_name, register.last_name, register.pri, register.priority_status, register.resolution, register.resolution_date
    FROM register
    WHERE ((([Search])=register.last_name))


    ORDER BY register.first_name;

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Don't let users view tables and queries. Users should interact with data through forms and reports. Forms can be set to not allow edits. Reports are not editable by their nature.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Lock control after data entry
    By Scott_80 in forum Programming
    Replies: 12
    Last Post: 01-07-2015, 03:35 PM
  2. Freeze panes in reports
    By Jamy in forum Reports
    Replies: 4
    Last Post: 01-02-2012, 03:19 PM
  3. Freeze Columns in a Form?
    By Paul H in forum Forms
    Replies: 9
    Last Post: 09-09-2011, 01:40 PM
  4. Replies: 4
    Last Post: 01-23-2011, 09:01 PM
  5. using VBA to freeze columns
    By bdaniel in forum Forms
    Replies: 1
    Last Post: 02-12-2010, 05:36 AM

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