User Profile

Collapse

Profile Sidebar

Collapse
smarta46
smarta46
Last Activity: Jun 15 '16, 12:31 AM
Joined: Jun 11 '16
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • smarta46
    replied to Access Multi User – Record Locking
    Thanks Nico.
    * After the "loser" gets the message and made his selection, the program will continue normally?
    * Is it possible to choose automatically the answer (ie If "WriteConfl ict" Then "SaveRecord " End If)?
    See more | Go to post

    Leave a comment:


  • smarta46
    replied to Access Multi User – Record Locking
    Hi Nico.
    Thanks for your reply.
    Actually I am using Shared with Nolocka too.
    I would like to know what happen if two users update the same record at the same momento (I know it wolud be a very Slim situation - It never happen to me):
    * Will the program crash?
    * Will I have a message diplayed letting me to choose what to do?
    * ...?
    See more | Go to post

    Leave a comment:


  • smarta46
    started a topic Access Multi User – Record Locking

    Access Multi User – Record Locking

    Hi.

    In Access 2010 it is possible to set the default Record Locking as follow:
    · File Menu
    · Click Options
    · Click Client Settings in the left side Options Menu Pane
    · Scroll through the Client Settings until you find the AdvancedSetting s
    Set advanced settings as:
    1. Default Open Mode – Shared
    2. Default record locking – Edited Record

    I would like to know:
    ...
    See more | Go to post

  • smarta46
    started a topic Access VBA Code Password

    Access VBA Code Password

    I need to “remove” the password in my “Access VBA Code” using VBA.
    I know that is possible for example with SendKey (Sending a Keystroke sequence) but I don’t know which is the Keystroke sequence to simulate “Alt+F11 - ToolsTab - Properties - (of course I know the password) – ProtectionTab - … - Accept”.
    If someone know the Keystroke sequence or another method using VBA I would appreciate.
    Of course I know...
    See more | Go to post
No activity results to display
Show More
Working...