Re: Import MS Access Forms

Geoff Muldoon wrote:
hiestand@xxxxxxxxxxxxx says...
I have a MS Access 97 database that needs to be converted to Oracle.

Is it possible to import MS Access forms into an Oracle development?

Short answer, no.

MS Access is really an application server with the MS Jet database engine integrated inside it.

Oracle RDBMS can replace (and massively out-perform) the Jet engine database, but it's front-end Oracle Forms component is a separate product, and is probably WAY too complex for anything built for just Access.

You can (with IMHO several significant reservations) move your data out to Oracle and still use your Access application components as the front-end, using the Oracle data via ODBC external tables.

Geoff M
Thanks for the info.

Andy
.

Relevant Pages

  • ANN: Oracle Data Access Components 4.50 released
    ... of native VCL/CLX components for direct access to Oracle server. ... Oracle Data Access Components provides high performance direct access ...
    (borland.public.delphi.thirdpartytools.general)
  • User Experiences with Data Pump Versus Legacy EXP/IMP
    ... terabyte of Oracle data from one disk array to another; ... The expdp says I can't open and write to the log file if its a map ...
    (comp.databases.oracle.server)
  • Re: Incredible Growing database....
    ... to both Access and Oracle backend tables. ... and Oracle data together. ... it looks just like the other kind of queries I've always ... That sort of thing.) ...
    (comp.databases.ms-access)
  • Re: Oracle Data Miner (ODM)
    ... >>I installed Oracle Data Miner on Linux platform (oracle data mining ... >>data miner can not establish a connection to oracle database server. ...
    (comp.databases.oracle.misc)
  • Re: Oracle Data Miner (ODM)
    ... >I installed Oracle Data Miner on Linux platform (oracle data mining ... >data miner can not establish a connection to oracle database server. ...
    (comp.databases.oracle.misc)