Access to Oracle FAQ |
| [MS Access to Oracle Converter] [Download] [Buy] |
This page exposes the most frequently asked questions about MS Access to Oracle converter. If some question is not answered here, contact to Intelligent Converters team using Feedback Form
What kind of database objects are migrated from MS Access
to Oracle server?
Access to Oracle database migration tool converts table definitions with the
related attributes, records, indexes, relationships between tables and queries.
It does not convert forms, embedded functions that are not complied with ANSI
standard of SQL and Visual Basic scripts. Demo version of the program has extra
restrictions: it converts only 50 records per table and does not convert
relationships between tables.
Go to Top
Does Access to Oracle converter require ODBC drivers?
No, the application does not require ODBC drivers. .
It connects directly to the source and target databases in order to achieve the
highest performance of the conversion process.
Go to Top
What are the system requirements for Access to Oracle database
conversion tool?
The product works on Windows XP (SP2 or SP3 is required), Windows 2003, Windows Vista,
Windows Server 2008, Windows 7/8/10. Also, it requires the corresponding version of
Microsoft Access or Access Runtime installed. Oracle components are not required.
Go to Top
Does MS Access to Oracle converter support automation?
The product does not have built-in support for automation. However, it is supplied
with console version a2oagent.exe that accepts command line arguments and can be
called from any script. In order to schedule the conversion, it is necessary to
create batch script and execute it recurrently using Windows
Task Scheduler. Read Command line article
of the product documentation to learn more about a2oagent.exe.
Go to Top
What versions of Microsoft Access and Oracle are supported?
The product supports wide range of MS Access versions starting from MS Access 97 and
up to MS Access 2016. Also it works with all versions of Oracle including Amazon RDS
and other cloud variations of the DBMS.
Go to Top
How to fix the error: "The file does not comply with
MS Access workgroup information file format"?
This error mostly appears when the name of Microsoft Access database file (.mdb,
.accdb) is entered into wrong box on "User-level Security Settings"
wizard page. That page is designed to specify MS Access workgroup information file
(*.mdw). If the source database is not protected with user-level security, keep all
fields on "User-level Security Settings" page empty. The name of Microsoft
Access database must be entered on "Select Databases" wizard page.
Go to Top
How to rename column in the resulting Oracle
table?
It is possible to change column name through converting the corresponding
table as result of SELECT-query. To use this feature click "Add Query"
button on "Select tables" wizard page and compose the appropriate
query. Read Using Queries article for the further
information.
Go to Top
How to change the target table name?
You can convert contents of the table as result of SELECT-query with custom name.
Click "Add Query" button on "Select tables" wizard page and
create simple query as follows:
SELECT * FROM <table name>
Then store the query with desired name and it will be converted in Oracle format
as if it is a regular table.
Go to Top
How to proceed with the error "Cannot recognize MS Access
database format..."?
Another reason is missing appropriate Microsoft Data Access (DAO) libraries on
the system. Access to Oracle database converter uses this library to read the source
database. In this situation it is recommended to install Microsoft Access
Runtime as it contains correct version of DAO libraries:
http://www.microsoft.com/en-us/download/details.aspx?id=10910
NOTE: if you have MS Office or Access 64-bit installation, it is required to
install 64-bit version of Access Runtime. Otherwise, you have to download 32-bit
versions of Access Runtime. If the error persists, contact
Intelligent Converters support service.
Do I need 32- or 64-bit version of the product?
How to uninstall Access to Oracle migration tool?
One possible reason of the error is that specified .mdb or .accdb file is not
a valid MS Access database or it has been corrupted. Try to open it in Microsoft
Access to make sure the file is valid.
Go to top
The answer depends on what version of Microsoft Access or Office you have. For
32-bit version it is required to install 32-bit version of Access to Oracle
converter. Otherwise, 64-bit version of the product is necessary.
Go to Top
If you need to remove the converter, use "Add or Remove Programs" option
of the Windows Control Panel.
Go to Top