I'm using Access 97 as a front end and connecting via ODBC to a SQLServer database.
I've written a rather large process within the access front end and it's all contained within a transaction. (I created the transaction within a workspace object).
My problem is that near the end of the process, but still within the transaction, I need to query some of the results created previously within the tranasaction. (I think that this kind of read is known as a 'Dirty Read', or more technically, an 'Uncommitted Read'; where you can read data that hasn't been committed to the database.)
The question is: is it possible to do this in Access 97?