Oracle Database Discussions

I'm in the process of migrating an app we have written to Oracle. It's a multi-tierd app with a common VB COM object writing to the database via ADO.
Initailly I had a problem with being unable to BatchUpdate records getting the following error:-
'Row cannot be located for updating. Some values may have been changed since it was last read.'
This I have found to be because Oracle by default updates on ROWID rather than Primary Key & have resolved by setting the 'Determine Key Columns For Rowset' property to True.
What I am now getting is an error 'ORA-00911: invalid character' when I'm trying to open a recordset with a particular SQL statement:-

"SELECT objectstable.objName, objectstable.objGroup, objectstable.Description,objectstable.Acquirer, Max(logfile.LogFileID) AS LastSubmissionID, Max(logfile.CutOffDateTime) AS LastRunDate FROM (acquirertable INNER JOIN logfile ON acquirertable.AcquirerID = logfile.Acquirer) INNER JOIN objectstable ON acquirertable.Name = objectstable.Acquirer WHERE objectstable.objGroup='Submission' GROUP BY objectstable.objName, objectstable.objGroup, objectstable.Description,objectstable.Acquirer;"

Running the statement directly in the database works fine with no errors, but as soon as I run it through code the error occurs.

Any ideas would be most welcome.

Cheers,
John