Oracle Database Discussions

Hi Experts,

I have taken up a project to migrate Access 2003 application to Oracle 9i.The Forms and Reports will continue to run in Access 2003 with Oracle 9i database. I decide to use Oracle Migration workbench for the migration purpose.What I think is the back-end i.e. database and queries will be automatically migrated to Oracle 9i but I'm not sure about the front end application.

Do I need to change front end application to point to database in Oracle 9i or OMW will do that itself.I am also confused with lots of queries that reside in current Access database. I presume these queries will be converted to Oracle procedures/views without any manual intervention but will the front-end application also be modified automatically to point to those stored procedures/views. Otherwise an extensive code change will be required which may result in huge cost.

Currently the Access application is not using any ODBC DSN as it gets connected to the database automatically. Should the database connection be changed to use DSN prior to Migration?

One more thing, the application is using single-level linked table. Will the linked table get automatically converted and connected or I need to do anything?

Could anyone help me in this issue by giving some ideas so I can manage the job efficiently and make proper planning before plunging into the real work.

Thanks & Regards
S C