prism.Question [2]: OLE objects and Access 2007

Dear Marvin team -

Following query is on behalf of our client, Dr. Marshall Pope.

Thanks,

anu

<<<<<<<<<<<<<<<prism.Question [2]: OLE objects and Access 2007  
>>>>>>>>>>>>>>>>

I'm trying to use the Marvin OLE server in an Access 2007 form
to display chemical structures.  I can copy Marvin Object from MarvinView
and paste it into an Access form, but the OLE type is set as
"embedded" and I need it to be set to "linked" so that I
can load .mol files.  I tried "object.Action = acOLECreateLink"
to try to force it into linked mode, but it didn't work.  Is it possible
to use the Marvin OLE server to display .mol files loaded by file name? 
Or is there another way to get the object to display data that is different
than what was initially copied in?

 

Thanks,

<<<<<<<<<<<<<<< 
prism.Question [2]: OLE objects and Access 2007  
>>>>>>>>>>>>>>>>

Hi!

We discussed the question with our OLE specialist, and we have to clear somthing before we can have the correct answer. Would Dr. Pope use our OLE server programmatically to open, edit and save mol file data in an Acces database that contains file path or even molfile data to every record?

Currently the linked OLE feature isn't supported, we have to discuss about the implementation, before we can say anything about how and when we can implement this.

He could probably try with a field that has OLE object as type, and use Marvin OLE object in embedded mode, but that currently cannot read mol file as the data source. If the embedded mode is suitable for the user, then we can add a functioanlity to the OLE server whith that he can programaticcaly set the mol data in the server.

Regards,
Istvan