1 Reply Latest reply on Aug 12, 2011 9:30 AM by Mkirtley-Oracle

    error while migrating from ms access 2003 db to oracle 10g in sqldeveloper

    831655
      Hello,

      i am working on migration project from MS access 2003 to Oracle 10g on windows XP sp2 plateform using SQL developer.

      it went quit smoothly till the "capture microsoft access" .so in this step the sql developer opens the access db in background... but while opening the file in background it gives error
      Object library not registered
      i tried many workaround but of no use..


      anybody's help in this regard would be well appreciated.



      thanks.
        • 1. Re: error while migrating from ms access 2003 db to oracle 10g in sqldeveloper
          Mkirtley-Oracle
          Hi,
          Did you follow all the steps in the SQL*Developer documentation about preparing the Access database for migration -


          Oracle® SQL Developer User’s Guide Release 3.0 -
          2.2.4.3 Before Migrating From Microsoft Access

          and -

          Oracle® SQL Developer Supplementary Information for Microsoft Access Migrations Release 3.0
          2.4 Preparing the Microsoft Access Database for Capture

          The error also indicates there may be a problem with your Access installation so could you check that everything is okay with that ? I have found references that indicate a re-install of Office/Access will prevent the error.

          Regards,
          Mike