Using JChem as ActiveX into MS Access

Hallo (although I made some searches I hope I am not duplicating any other posts...),

I already made the connection with MS Access, and imported an SD file into it thanks to JChem Man.

I need to know if it's possible to visualize and search molecule by means of an embeddable object to be place into an MS Access form (e.g.: like texbox or frame or subform etc...).

More in general: if my backend is anyway MS Access what do you suggest as for structure visualization?

I thank you in advance.

From visualization point of view I have attached two examples how to use Ms Access or VBA code to invoke Marvin OLE as embedded object.

The Marvin OLE Access Demo contains a simple Demo table and View with 4 structures and ids. The Form View contains a predefined Form against this Demo table, if you double click on it, it gets the Form running where you can browse, edit and add records.
If you want to programmatically use the embedded OLE object, its automation interface can be achieved in Macro module view but need to get the raw OLE object instance from Ms Access first.

For OLE automation interface you can see another VBA example written in Excel
to demo automation interface of OLE. This interface is what I mention above as option for you programmatically accessing the COM object. The macro module contains a Form invoking Marvin OLE automation module, properties, mehtods and it handles and forwards Marvin OLE events as well.

 P.S.: Marvin OLE.mdb cannot be uploaded as Access Database since the Forum does not accept mdb files to be attached so now it is Zipped please unzip it before use

If you do not insist on Access GUI, you could use any interface available originally for JChem Base.

(E.g. the demo web application, like this one: http://www.chemaxon.com/jchem/examples/db_search/index.jsp )

Furthermore, if you do not insist Access as a DB (), you should consider Instant JChem:

http://www.chemaxon.com/product/ijc.html

It comes with an embedded database engine, and can be a chemically aware substitute for Access...

Best regards,

Szabolcs

Hi,

If you want to search in your chemical database with the JChem from an Access application I can suggest two ways:

1. You can use .NET API for JChem. It is downloadable from the JChem download site: http://www.chemaxon.com/jchem/download.html />You can find the requirements and introduction in the JChem developer's guide: http://www.chemaxon.com/jchem/doc/guide/intro/dotnet.html />Our detailed .NET developers's guide will be available in the next major version (5.3 is expectedly released in December).

2. you can use JChem as a web service: http://www.chemaxon.com/product/jc_webservices.html />You will be able to find C# and unmanaged C++ example for accessing JChem Web Services from .NET and Com based applications in the JChem 5.3 next month.

In these cases you can care for the multiser mode of MS Access, because JChem needs an own database connection for the searching.

 

Regards, Edvard