Hi Guys,

I am trying to update a field in a MS Access DB with the input from a ListView Control. But the problem is field in the MS Access DB has a releationship to a similar field in a different table (in the same DB) so its not letting me update this record. Any thoughts on getting around the problem??
Thanks for your help ...
Some of the code looks like as follows:

Viji


Public Sub AddRightsToDB()
Dim SQL2 As String


If Not cnn.State = adStateOpen Then
OpenConnection
End If

If cnn.State = adStateOpen Then

SQL2 = "update USER_RIGHTS set Access_Level = ('" & AccessLvl & "')where User_Name='" & Uname_Rights & "'"

rstNewRights.Open SQL2, cnn, adOpenForwardOnly, adLockOptimistic

CloseConnection


End If
End Sub