Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access 2000 adp file won`t work in access 2007

Status
Not open for further replies.

doquigley

Technical User
Jan 16, 2006
12
IE
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top