everytime when I try to use "autonumber" field in SQL statements, it always give this error:
Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression
I'm trying this expression:
set rsproj = conexao.execute("select * from projetos where id = '" & rs("projeto") & "'")
id-> is an autonumber field of a table called "projetos"
rs("projeto") -> is a number that is caught of another table called projs
anything wrong ?