Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, UK, Berkshire, England
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Setting Access options (2000 - 2003)

    Is there anyway to check what options a user has set in their Access environment ?
    - specifically what they've got "Default record locking" set to ?

    Even better, is there someway to set it in VBA

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

    Re: Setting Access options (2000 - 2003)

    Look up GetOption and SetOption in the online help for Access VBA. For a list of options, look up "Set Options from Visual Basic".

    Dim bytRecordLocking As Byte
    bytRecordLocking = Application.GetOption("Default record locking")

    Application.GetOption("Default record locking") = 2 ' Edited record

    0 = no locking
    1 = all records
    2 = edited record

Posting Permissions

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