Access front end Error
737578Jan 15 2010 — edited Jan 15 2010I''m using MS Access as a simple application to access engineering back-end Oracle information to run reports on, etc. This is deployed to the users via a network share.
The application probably uses about, say, 15 SQL Pass Through queries (Using the Microsoft ODBC for Oracle Driver) to access the relevant data on an Oracle 9i Database.
Strangely, all the SQL Pass Through queries work (With exactly the same connection string), apart from one! When I try to access this from their client machines I get;
""
ODBC--Call failed.
(Microsoft)(ODBC driver for Oracle)(Oracle)ORA-00511: Message 511 not found; product=RDBMS; facility=ORA(#511)
""
All the other Pass Through's work fine, and on the Admin Client where I build the Access Application it works fine too. I'm stumped as to what the problem could be.
Any help would be greatly appreciated.
Luke
Edited by: user12282018 on Jan 15, 2010 12:51 AM