Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2012
    Posts
    6

    Unanswered: Problem With Attachment

    Hay Guys !
    I need your support
    I Have a form includes Attachment control
    the problem is if two users opens the same form they can`t attach files at the same time and Err MSG said this control is locked so, please advise
    and i want to make the attachment work through VBA so please, advise about the code and dialog box appears to select and save the file .

    Thanks In advance

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Is the application split (FE/BE model)? Is there a copy of the FE on the computer of each user?
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Can we see the code you are currently using

    I suspect that your code is securing an exclusive lock on a table

    I cannot see how you could get a lock on a control with two users irrespective if the app is split (as it shoudl be)
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Mar 2012
    Posts
    6
    Quote Originally Posted by Sinndho View Post
    Is the application split (FE/BE model)? Is there a copy of the FE on the computer of each user?
    I`m sorry i`m new in access {i don`t know what you talking about}
    kindly clarify

  5. #5
    Join Date
    Mar 2012
    Posts
    6
    Quote Originally Posted by healdem View Post
    Can we see the code you are currently using

    I suspect that your code is securing an exclusive lock on a table

    I cannot see how you could get a lock on a control with two users irrespective if the app is split (as it shoudl be)
    I`m just using macros and the users use the same form from different PCs
    the problem happens if they using attachment at the same time and i attach the file kindly check
    Attached Files Attached Files
    • File Type: zip J.zip (195.5 KB, 1 views)

Posting Permissions

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