Reading uncommitted data with MS Access

Hello,

I am writing a stand alone application in Delphi and I am using MS
Access to store all the application data. The application uses the ADO
components that shipped with Delphi 2006. To implement the 'Save'
feature, I simply create a transaction when the application starts.
When the 'Save' button is clicked I commit the current transaction
and start a new one. However, the queries are not reading changes that
are made during the transaction. Does anyone know why this might be
happening? I have tried fooling around with the IsolationLevel but
that was no help. I'm assuming it was no help because there is only
one transaction at any given time.

Thanks for any help.

.

Quantcast