Save OLE Object via VBA to linked SQL Server 2005 table

L

Londoner101

Hi all,

I'm trying to save documents (Word, Excel) via VBA in an Access front
end to a linked SQL Server 2005 table with a field defined as a
varbinay (equivalent of OLE Object in Access)

I found the following sample code at the link below.

http://support.microsoft.com/kb/210486

The issue I have is that the code works fine if my table is a Access
table with a field of type OLE object. However when I try and use the
linked SQL Server table I get the following exception thrown on the
Update() method of the recordset.

"ODBC--update on a linked table 'dbo_Blob' failed."

My table in SQL Server does have a primary key defined.

Any asisstance, suggestions and direction greatly appreciated,

Thanks

Raj
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked OLE Object 3
Linked SQL table 4
How do you use a checkbox with a linked SQL Server 2005 table? 5
How To programmatically add and retrieve documents using OLE Objects 2
Linked Table Cant Delete Record 2
Linked Table Question 2
Append Access Data to SQL Server Table 12
Insert Into a SQL table via Access 2007 8

Top