Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010
    Posts
    18

    Unanswered: Best way to view read-only data?

    I want to give employees read-only access to anything appropriate to their job title.

    For example: Employee Jim needs to be able confirm training course details (when, where, etc) for a customer.

    I'm guessing a read-only view of the Bookings table would be the way to go? Is something like this best done with a canned query or a form?

    Thanks - rev

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You can make a query read-only with the following code:
    Code:
    Function LockQuery(ByVal QueryName As String)
    
        Dim dbs As DAO.Database
        Dim qdf As DAO.QueryDef
        
        Set dbs = CurrentDb
        Set qdf = dbs.QueryDefs(QueryName)
        qdf.Properties("RecordsetType").Value = 2
        Set qdf = Nothing
        
    End Function
    You can also set the RecordsetType property of the form to Snapshot.
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    another approach is to set the read/write attributes at the time the form/application is opened based n that users permissions
    you could use workgroup permissions, you could write your own security table, you (in my books) should use the network logon.

    open the form, and if the user has appropriate permissions allow them to make changes.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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