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
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