datatype mismatch in criteria expression to Access Database

Hi,


I get this error "datatype mismatch in criteria expression" in my sql query. One of datatype in my Acceess database is declare as "Number-Long Integer".


This cause error occur while the datatype mismatch. I'm using asp.net with vbscript to code my page. In my sql query, there is a condition.


CodeBehind:


Dim strabc as (Integer/Long/Short/Single,Int32,Int64/Byte...)<- I had try all of this data type but still error!


strabc = CType(textbox.text,Integer/...)
Query = "Select * from table where abc = '" &amp; strabc &amp; "'"


Microsoft Access Data Type:
abc - Number-Long Integer


It is easy to use if I declare abc in DB as "Text". IS ANYONE KNOW HOW TO SOLVE IT??? what should delare the variable in my code behind page??


Thank you very much


Calvin

 

The solution solved my problem. Thanks for your help.

Calvin