Results 1 to 2 of 2
  1. #1
    Secue is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    33

    Question Lock record on a query result

    Hi:



    I have a query that provides result form two tables based on inputs I made form a form. My problem is that once I run the query and got the result on the query window, I'm able to modify the information showed on the query result and this is recordé on the tables, I want to change this to avoid any user once they run a query can modify values.

    Do I have to set any special condition or settings on the query?

    Thank you.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Don't let users interact with tables and queries. Users should interact with data through forms and reports. There are techniques to accomplish but be aware that most can be overridden by any minimally knowledgeable user.
    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. Replies: 3
    Last Post: 08-03-2012, 02:37 AM
  2. Replies: 9
    Last Post: 05-12-2012, 12:16 PM
  3. Help with a basic record pause or lock?
    By valkster in forum Programming
    Replies: 0
    Last Post: 03-12-2012, 06:14 AM
  4. Replies: 1
    Last Post: 07-13-2011, 11:30 AM
  5. lock a record
    By Nokia N93 in forum Programming
    Replies: 3
    Last Post: 02-21-2011, 02:51 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