| msaccess sql to ansi sql [message #371495] |
Mon, 30 October 2000 09:14  |
Tony Austin
Messages: 1
Registered: October 2000
|
Junior Member |
|
|
We currently have several data analysts (around 20) that use MSAccess 7.0 to connect to our Oracle 7.3.4 database(s) via an Intersolv ODBC Driver. Aside from the fact that the odbc connection is slow, access writes really horrible sql statements. Does anyone know of a utility that can translate the sql statement that Access creates into a more readable and better functioning sql statement? Any suggestions or ideas would be greatly appreciated.
Thanks. Tony
|
|
|
|
| Re: msaccess sql to ansi sql [message #371498 is a reply to message #371495] |
Mon, 30 October 2000 11:18  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Hi,
The interaction between Oracle - Access - ODBC is awful.
- ODBC is slow - but one can construct sql-Statement manually [[either by programmining DoCmd.RunSql or by Query-Wizzard (use the sql-view in the the query-maker)]]. If the Odbc-Driver does not transfer data back fast enough - malfunctions can appear. These malefunctions can not be intercepted.
- Use of native Oracle-Driver (programming / OracleOpenObjects) is the better soulution !
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
