Mary Chipman [MSFT]
7/7/2008 2:52:00 PM
There are a few things you can do:
1. For result sets that you want to be read-only, create and save
SELECT queries (setting the Recordset Type to Snapshot) instead of
selecting data directly from the tables.
2. Don't select a bazillion rows for browsing -- fetch in
reasonably-sized batches. People can't view thousands of rows at once
anyway.
2. Keep all data modifications short. IOW, select only the row from
the table being changed. Access/Jet uses row-level locking, so you
shouldn't have blocking or concurrency issues unless two users are
concurrently modifying the same row at the same time.
--Mary
On Thu, 3 Jul 2008 09:16:00 -0700, JorgeC
<JorgeC@discussions.microsoft.com> wrote:
>Hi!
>Im some situations I want to change IsolationLevel to ReadUncommited because
>the columns(fields) I want won't be changed by the users that maybe updating
>table A (lets call it table A).
>We have many users reading some columns that won't be changed by those
>update the records.
>If I use ReadCommitted and someone is updating this record(or set or blocks)
>those that are just trying to read the rows (some users don't even care that
>the data may be dirty) will be blocked until the update operations are
>finished.
>
>Thanks.
>Jorge C.
>
>"Mary Chipman [MSFT]" wrote:
>
>> What are you trying to achieve--what problem you are trying to solve?
>> ADO.NET doesn't work the same way ADO did, so there are many things
>> that are missing. If you provide a use case scenario, someone can jump
>> in with advice on how to achieve your goal.
>>
>> --Mary
>>
>> On Tue, 1 Jul 2008 06:20:03 -0700, JorgeC
>> <JorgeC@discussions.microsoft.com> wrote:
>>
>> >Hello!
>> >How can I set the connection Isolation level for a Access database using
>> >System.Data.OleDb?
>> >
>> >In old days ;) of Visual Basic 6 and ADO we had the IsolationLevel property
>> >in the connection object.
>> >But in ADO.NET System.Data.OleDb I can't find anything to set the isolation
>> >level!!
>> >
>> >So, does anyone know how to set this ?
>> >Thanks for your help and attention.
>> >Jorge C.
>>