Oracle to Access FAQ

On this page you can find the most frequently asked questions regarding Oracle to MS Access converter. If your question is not answered here, contact Intelligent Converters team.

• What versions of Oracle and MS Access are supported?
• I have multiple Oracle homes installed on my system. Can this cause a problem while using Oracle to Access converter?
• Why do I get the following error: "ORA-06413: Connection not open"?
• What does this error means: "ORA-12705: Invalid or unknown NLS parameter value specified"?
• What are the system prerequisites for Oracle-to-Access?
• How to bypass error "ORA-12640: Authentication adapter initialization failed"?
• What if I don't have direct connection to Oracle server?
• Does Oracle-to-Access converter support automation?

What versions of Oracle and MS Access are supported?
Oracle to Access database migration tool works with all versions of Oracle servers running on Windows, Linux/Unix platforms. Amazon RDS and other cloud variations of the DBMS are supported as well. Also, the database converter supports Microsoft Access versions starting from 97 and up to 2021.
Go to Top

What are the system prerequisites for Oracle-to-Access?
Oracle-to-Access needs only corresponding version of Microsoft Access installed. Oracle components are not required to convert Oracle data into MS Access format.
Go to Top

What if I don't have direct connection to Oracle server?
You need to export Oracle database into dump file using Oracle EXP tool (see manual on this tool). Then you can convert that dump file into MS Access format using our OraDump-to-Access converter.
Go to Top

Does Oracle-to-Access converter support automation?
Oracle-to-Access converter does not support automation directly. However, there is console version of the program o2aagent.exe in the installation directory. It supports command line arguments and can be called from any script. So, it is possible to write a simple batch script and execute it recurrently using any Windows scheduler. Please refer to 'Command line' article of the product documentation for the further information.
Go to Top