I would like to store all of my data in an Oracle database. How can I achieve that?
Your Oracle database must have a MolTable. The MolTable needs to a have a field called MOL_ID. This field should be a (9,0) Number; i.e. a Number with a Precision of 9 and a Scale of 0. Launch Access 97 (you must use 97 because of a problem with 2000), and attach your Oracle tables to the new database. When ChemFinder opens this table after you have attached it, it will see the MOL_ID field and understand it to be a structure field. Launch ChemFinder and create a form, set the datasource to the MDB file containing the attached Oracle datasource.