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

    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
    rsParent.MoveLast

    rsParent.Edit

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

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

    rsChild.Update
    rsParent.Update

    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
    Location
    Richmond, Virginia USA
    Posts
    2,763
    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 foolproof...is 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
  •