Reading uncommited data

[swapna_munukoti]

Hi all,

Is there a way to read uncommited data in MS Access.
That is user1 has started a transaction and is inserting records
into table1. User1 is yet to commit. Now User2 wants to select those
uncommited records. Is there any feature in MS access similar to
"NoLock" as in SQL Server 2000.

Thanks in Advance,
Swapna.

 

[Van T. Dinh]

No, if the data is uncommitted into the Table, the data exists only in the
Form's buffer of the user who enteres the data. Note that each user should
run an independent copy of the Access Front-End.

 

[swapna_munukoti]

Hi VanT.Dinh,
Thanks for the suggestion. But we are using an ADO connection from
VB6.0 and connecting to MS Access 2000. In our application all the data
are processed with a scope of transaction. Our application is also a
multi user application. So, when an user1 downloads in a mass, then
user2 should be able to view the records that are being downloaded. Can
you suggest an solution in such a scenario.

Thanks
Swapna

 

[Van T. Dinh]

To be precise, you are only using the JET database engine, not Access.

Sorry, I only use basic Transactions with DAO and not ADO.

Suggest you re-post to one of the newsgroups for VB, possibly relating to
ADO instead. You can also try the newsgroup
"microsoft.public.access.modulesdaovba.ado"