Hi all,
Not sure how easy or hard this is, couldn't find a match within the search that hit my criteria.
We have a third party software which stores all of the data within a sql server.
An access database has been setup to fish out information for reporting not including within the system
Within the third party sql it holds images against records in 'image' fields
My problem is how can i get access to show these within forms or reports.
Have been playing with this for a few hours and can't seem to get it to play ball.
The simple approach obviously is to pull the record into the forms recordset, i used the actual field (drag and drop) from the fields list which created a bound ole object but when i open the form i simply get a blank box...
if i double click the blank box i get the message
A problem occurred while microsoft access was communicating with the ole server or activex control... close the ole server and restart it outside microsoft access. then try the original operation again in microsoft access....
no help there then,
so tried to dupe it a little and create an unbound ole object and specify it as an image, then on open it sets the source of itself to the field i need from the database using a new source object referring back to the id field on the form.... score... not so lucky, i get this error now
Microsoft access can't read the ole object because communication was interupted... pretty much like the one above!!!
checked the references, activex data objects are there (just a thought!!!)
has anyone successfully used images stored as 'image' type from sql server within a form or report??
(i usually reference images and store on network drives, but i cannot modify the software!!!)
any help is greatly appreciated...
cheers
davejam
Not sure how easy or hard this is, couldn't find a match within the search that hit my criteria.
We have a third party software which stores all of the data within a sql server.
An access database has been setup to fish out information for reporting not including within the system
Within the third party sql it holds images against records in 'image' fields
My problem is how can i get access to show these within forms or reports.
Have been playing with this for a few hours and can't seem to get it to play ball.
The simple approach obviously is to pull the record into the forms recordset, i used the actual field (drag and drop) from the fields list which created a bound ole object but when i open the form i simply get a blank box...
if i double click the blank box i get the message
A problem occurred while microsoft access was communicating with the ole server or activex control... close the ole server and restart it outside microsoft access. then try the original operation again in microsoft access....
no help there then,
so tried to dupe it a little and create an unbound ole object and specify it as an image, then on open it sets the source of itself to the field i need from the database using a new source object referring back to the id field on the form.... score... not so lucky, i get this error now
Microsoft access can't read the ole object because communication was interupted... pretty much like the one above!!!
checked the references, activex data objects are there (just a thought!!!)
has anyone successfully used images stored as 'image' type from sql server within a form or report??
(i usually reference images and store on network drives, but i cannot modify the software!!!)
any help is greatly appreciated...
cheers
davejam
