Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012

    Exclamation Unanswered: Attachment locking the entire DB !!!

    Hay guys
    I just need help
    i have access BD and every one use it through shared folder
    my problem is in attachment ! , if i use the regular attachment filed in access there is one user only able to attach files and others can`t attach any thing until he finish
    i tried to do attachment through VBA like below which make it worse as it lock the DB so, no one can even open the DB and one user only access the DB

    Dim db As DAO.Database
    Dim rsParent As DAO.Recordset2
    Dim rsChild As DAO.Recordset2

    Set db = CurrentDb
    Set rsParent = me.Recordset


    Set rsChild = rsParent.Fields("Attachment").Value

    rsChild.Fields("FileData").LoadFromFile "file path"


    Set rsChild = Nothing
    Set rsParent = Nothing
    end sub

    appreciate your help how multi users attach files at the same time without locking the DB

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Why don't we work this from a single thread:

    Attachment locking the entire DB !!! - Access World Forums

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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