Good day guys.
I want want a little help of my query.
The tbl_ entity:
tbl_1(UserId(AutoNum
ber - set as primary key),Validity(Date/Time))
dim logonid as long
rs.open "SELECT * FROM tbl_1 WHERE UserId='" & logonid & "'",conn, adopenkeyset,adlockoptimistic
It returns an error invalid data type expression. But when i changed the UserId datatype to Text it will works..Whats wrong with the AutoNumber datatype?
Ex. if logonid has a value of 2, even if the value is in the database it returns the error invalid data type expression.
Thank you guys for giving time.