F
fmstek
I am trying to create an MS Access form with which to view records read from
a SQL Server database on a remote server. Each record contains an image of a
MS Word document. The data type in SQL Server is "Image".
In Access, when I link to this table, the Image field becomes Access data
type "OLE Object".
My Access form is based on a query joining this linked SQL Server table with
other tables on the remote db. I am trying to display the Image field in an
Access Bound Object Frame, but am unable to do so. When I run the form, each
record displays complete with ordinary text or numeric data, but not the
Image field. When I double-click the frame, I get this message:
"A problem occurred while MS Access was communicating with the OLE Server or
ActiveX Control. Close the OLE Server and restart it outside of MS Access.
Then try the original operation again in Microsoft Access."
I have no idea what to do here. I'm not even sure what an OLE Server is.
Reminder: this data to be displayed is not on my PC (outside of the Access
db), it is in the SQL Server database for CAMS (remote server).
I am using MS 0ffice 2007 with Windows XP. I have some familiarity with
Visual Basic and am not averse to writing VB code -- the simpler the better,
of course.
Thanks in advance,
a SQL Server database on a remote server. Each record contains an image of a
MS Word document. The data type in SQL Server is "Image".
In Access, when I link to this table, the Image field becomes Access data
type "OLE Object".
My Access form is based on a query joining this linked SQL Server table with
other tables on the remote db. I am trying to display the Image field in an
Access Bound Object Frame, but am unable to do so. When I run the form, each
record displays complete with ordinary text or numeric data, but not the
Image field. When I double-click the frame, I get this message:
"A problem occurred while MS Access was communicating with the OLE Server or
ActiveX Control. Close the OLE Server and restart it outside of MS Access.
Then try the original operation again in Microsoft Access."
I have no idea what to do here. I'm not even sure what an OLE Server is.
Reminder: this data to be displayed is not on my PC (outside of the Access
db), it is in the SQL Server database for CAMS (remote server).
I am using MS 0ffice 2007 with Windows XP. I have some familiarity with
Visual Basic and am not averse to writing VB code -- the simpler the better,
of course.
Thanks in advance,