I am currently designing a windows forms based help desk system in Visual Basic .NET I have recently started testing in a multi-user environment and discovered that a pessimistic record locking scheme is required for this type of data entry. My dilemma is that I do not know how to call the Pessimistic record locking from VB .NET. I am using and OleDb Data Adapter to connect to Access and passing the same user name for every connection and managing security on my end instead of access.
I have read about the option of flagging the record myself and then deleting after the user is done saving. But I also have heard the down sides of this method and wish to avoid them at all costs. Any and all suggestions are greatly appreciated!
__________________
Jordan Byron
Integrity Systems and Solutions, LLC
Record locking Access 2002 Via VB .NET
Hot Topic
- The requested name is valid and was found in the database
- Binding to collection of objects
- Combobox event usercontrol
- Binding a DataGridList to existing custom data via the "custom business object" approach?
- ContextMenu not working
- The new .NET 2.0 ConfigurationManager and Associated Classes
- One or more error occured while loading the designer... why?
- Merging ContextMenuStrip to ToolStripMenuItem
- Master Detail grid with typed dataset.
- multiline datagridview cells?
Windows Forms
- Dock My Windows Main Form
- Exporting Dataset to Excel in a Widows Forms Project (Not ASP)
- Control Question
- Deploying Extra Files Preserving Folder Structure
- I need to run an exe as part of the install
- CodeDom & InitializeComponent
- Datagridview onMouseClick onMouseDoubleClick
- Binding ToolStripComboBox?
- Binding to DataRow / DataRowView problem
- Tooltip do not reshow after they expire
Record locking Access 2002 Via VB .NET
hamdi4u
I am using ADO.NET and trying to start a transaction with a OleDb Connection that I know works. I get the message
quote:
Neither the isolation level nor a strengthening of it is supported
The code I am running is as follows
code:
Dim txn As OleDb.OleDbTransaction
OleDbConnection1.Open()
Try
txn = OleDbConnection1.BeginTransaction(IsolationLevel.Serializable)
OleDbDataAdapter1.SelectCommand.Transaction = txn
OleDbDataAdapter1.Fill(DsCustomers1)
Catch ex As Exception
MsgBox(ex.Message)
End Try
I have been able to use other IsolationLevels, with only the exception of Serializable and RepeatableRead. If anyone has encountered this problem or knows a solution I would appreciate some feedback!
bafidi