Help with pass-thru queries from MS Access 97

Hi,

I have a few pass-thru queries that I wrote for users to run from Access 97. They all run fine.

However, there is one that does not seem to want to work. It is: Set Transaction Use Rollback Segment rb_large (rb_large is a valid rollback segment in our system).

For some reason I get a driver error when I put a ; at the end of the query, even tho my other pass-thru queries all have the ; at the end. I have tested the others without the ; and they run fine, so I assume that I can run the "Set" query without the ; as well.

The problem is this: after running this passthru query, I run a normal update query from Access, but the query does not use rb_large, it uses one of the normal default rollback segments.

When I run the same "Set" query from SQL*PLUS, followed by the same "Update" query, it does use rb_large...this process just doesn't seem to want to work from Access.

Does anyone have any ideas? I appreciate your help!!! Andy

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!