All Access QueryDefs are translated into Oracle PL*SQL views, procedures, and packages, including variable column Crosstab queries and multiple table updates. Oracle Views are created from Access Select, Union, and Crosstab queries and Oracle Procedures are created for all Access Action (Update, Append, Make Table, and Delete) queries and variable column Crosstab queries. Parameters are fully supported for all queries.
Most Access built-in functions are translated into equivalent Oracle functions. In addition, Scriptoria deploys a package that implements many non-standard Access functions like DateDiff and DatePart. Oracle functions are generated to implement Access IIf() conditional statements.
The VarP and StdVarP aggregate functions and domain aggregate functions DFirst, DLast, DVarP, and DStdVarP are not supported.
Some incompatible VBA functions like Environ and CodeDB.
Access queries that call VBA user-defined functions are translated, but the VBA functions themselves are not. They must be converted to Oracle manually.
No distinction is made between the MS-Access Unique Rows and Unique Values options. A warning message is issued when Unique Rows is encountered.