I have an access adp project file that I created on access 2000, when I try to run it in access 2007 it just doesn`t recognise the sql cmd instructions and I get the error "the text, ntext, and image data types cannot be compared or sorted except when using IS NULL or Like Operator, which makes no sense in the code that it hangs on
Private Sub ctrInitials_AfterUpdate()
Set cmdUser = New ADODB.Command
With cmdUser
.ActiveConnection = cnnCCare
.CommandText = "SELECT * FROM tblUsers WHERE Initials = (?)"
.CommandType = adCmdText
.Execute Parameters:=Forms!frmStartUp!ctrInitials
End With
End Sub
The solution must be simple - I try to be simple
Private Sub ctrInitials_AfterUpdate()
Set cmdUser = New ADODB.Command
With cmdUser
.ActiveConnection = cnnCCare
.CommandText = "SELECT * FROM tblUsers WHERE Initials = (?)"
.CommandType = adCmdText
.Execute Parameters:=Forms!frmStartUp!ctrInitials
End With
End Sub
The solution must be simple - I try to be simple