MS-Access passthrough query to Oracle

I am trying to write a pass-through query in MS Access to truncate 2 tables in Oracle. It goes exactly like this:

truncate table NYOHB DROP STORAGE
truncate table T900OHB DROP STORAGE

I keep getting a ORA-00933 error message:SQL command not properly ended.(#933).

If I execute just one of the truncate statements, it works perfectly fine. If I add any other SQL statement the first truncate statement, I get this error message.

I have tried a ; after each statement and get an "invalid character" error. I have also tried a "/" between each line and get the #933 error message again.

Does anybody know how to execute more than 1 SQL statement in a single passthrough  query in MS-Access?

Thanks for the help

Dave Smith

dgsmith_at_wb.xerox.com Received on Wed Jun 05 1996 - 00:00:00 CEST