I am trying to lock a record from a .mdb with OLEDB using .NET. How do I do that?
How can I lock an entire table as well?
views:
73answers:
1
A:
When opening your recordset, you should be able to declare a locking strategy at the record level, either optimistic (meaning the record is locked at update time only) or pessimistic (the record is locked from the begining of the edit process untill update time).
I am not sure you can lock a whole table through oledb connection. Why don't you open it 'read only'?
Philippe Grondier
2009-09-28 14:28:49
can you write some sample source code just to get an idea?
Killercode
2009-09-28 14:35:09
Er, you need sample code for choosing a parameter for opening a recordset? Surely you already know how to open the recordset, so it's simply a matter of checking in the documentation for OLEDB exactly what the options are that can be supplied as parameters to the command that opens your recordset.
David-W-Fenton
2009-09-28 20:12:33
You took the words out of my mouth ....
Philippe Grondier
2009-09-29 07:49:28