Dr. Ferenc Nagy wrote in message ... >On Fri, 19 Feb 1999, Peter Chong Sr. Systems Analyst (MRP/ERP) wrote: >Dear Peter, >> >> Next step on client side, >> I have ODBC/32 with SCHEMA EDITOR from MINISOFT >What is that schema editor? A. Schema Editor is 1. kind like translation tool for image for example you have Double Integer in Image with COBOL format pic 9(7)v99 comp. Image store 12.34 to 1234 and you directly link ODBC/32 to IMAGE MS Access and Excel shows 1234 instead of 12.34 Schema Editor convert 1234 to 12.34 2. It reads flat file MPE or SD format (IMAGE save, old HP list0 and COGNOS quiz subfiles in HP3000 to client PC directly via TCP/IP connection. Avoiding up and download process between HP3000 and Windows 95,98, NT. >Is it able to generate MS Access table definitions form TurboImage >database schema files? A. Yes Link Table with ODBC User DSN or Machine DSN. >Do you know about a tool which helps to plan MS Access tables outside of >MS Access? A. Any Office 97 product with MS query, I tried Excel with external data source Suppose you have a small DOS machine without MS Access and >Windows NT at home, and you have some free hours on Saturday afternoon. >You type in the table definitions in a flat file, like the TurboImage >schema file. On Monday you translate the flat file into a MSA table >definition, like DBSCHEMA did it for TurboImage. A. I rather create IMAGE source schema from any text editor and upload to HP3000 and run DBSCHEMA > >Do you know a TurboIMage -> MS Access 7.0 database schema converter? > A. Ok, Schema editor or ODBC/32 will translate IMAGE to ODBC compatable Data source to PC via TCP/IP link, I just use Access97 v.8 to link ODBC table (HP 3000/IMAGE) > > more info refer www.minisoft.com May be some information is debatable, I just try best to help, I think best tool for HP3000 since MPE II (77) > Frank > > |\ /~ ~~|~~~ Family : NAGY; first name : FERENC; title : Ph. D. > | \ | | Institute of Isotope and Surface Chemistry > | \ | -+- H-1121 BUDAPEST Konkoly-Thege M. ut 29, (1525 Bp. POB 77) > | \ | | [log in to unmask] (36-1)-395-9123 Fax: ~395-9002 > | \| | http://alpha0.iki.kfki.hu/~nagyf/ >`-' ' `-' Home: H-1102 BUDAPEST Holgy u. 48. I. 8. (36-1)-262-1198. >You need three virtues in the life: >1. strength - to change the things which are changeable, >2. patience - to endure the things which are unchangeable, >3. wisdom - to distinguish the above two kinds of things. >