Hi, I am having a really hard time with my SQL Server db and MS SQL 2002. I am getting an error saying "Another user is updating the same record as you." There is nobody else using the db since I am developing it and I am not sure why this is happening. The project is in trouble because we need to send this out to UAT next week. I have attached a copy of some of the code below and any help would be greatly appreciated.
Dim rs As New ADODB.Recordset
If PubActHistPend = "P" Then
sql = "SELECT * FROM " & sTable & " WHERE " & sTableID & " = " & nCurRec
Set rs = OpenADORecordSet(sql)
If rs.RecordCount > 0 Then
rs!Status = "H"
rs!ChgCode = "X"
rs!ApproverName = PubUser
rs!ApproverTime = Date & " " & Time()
Inactivate = True
MsgBox "There was an error trying to delete record. Please contact programmer."
'Me.RecordSource = "SELECT * from Holiday where Status = 'P'"
This is the OpenADORecordSet code
Public Function OpenADORecordSet(ByVal Source As String) As ADODB.Recordset