
Recordset & Bound Object Frame
Dear All,
I've got a form containing a "bound object frame", which is used in
order to select an attachment (Word, Excel file, ...).
My problem resides in the fact I don't succeed in storing the content
of this "bound object frame" in the database. I need to do it via
source code.
My table definition is the following:
table: tbl_contentFields:
...
c_object Ole Object
The following piece of code returns the following error:
"Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done."
Error : -2147217887
Here is my source code:
strSQL = "SELECT * from tbl_content WHERE " & _
" w_id = " & txtWich.Value & _
" AND h_version = " & txtVersion.Value
On Error Resume Next
Err = 0
rstContent.Open strSQL, CurrentProject.Connection,
adOpenKeyset, adLockPessimistic
If (Err <> 0) Then
MsgBox Error$ & "(" & Format(Err) & ")"
GoTo lbl_leaveprocedure
End If
If (Not rstContent.EOF()) Then
rstContent!c_freetext = txtFreeText.Value
rstContent!c_title = txtTitle.Value
rstContent!c_object = oleObject
<========
rstContent.Update
End If
If (Err <> 0) Then
MsgBox "Update failure2"
End If
rstContent.Close
Could someone help me ? I need to deliver the application in the next
couple of days ?
By advance, many thanks
Didier Boelens,