I have been completely stymied by the above error msg. I am attempting to query from Access 2003 to an Oracle backend (10g).
here are the statements.
SELECT dbo_IDMAP.OBJID, dbo_IDMAP.ID
FROM dbo_IDMAP INNER JOIN dbo_Greggs_CaseII_ObjId ON dbo_IDMAP.OBJID = dbo_Greggs_CaseII_ObjId.OBJID
WHERE (((dbo_IDMAP.TYPE) Like "S*") AND ((dbo_IDMAP.ACTIVE)="1"))
WITH OWNERACCESS OPTION;
it returns ora 933, but I can't find anywhere that statement is not properly ended. I've experiment with changing various clauses only to find the error morph into another error. I am running it as owner also. I created this as a Select query in Access first then switched it to a SQL Pass-thru that is when the error is generated. Obviously, Oracle has a different version of SQL that what Access employs. I just need that one little code error that is causing this.