The datatype for all argument values must be consistent with the datatypes of the relevant columns:
Any argument declared as numeric can be used with any numeric column.
Any argument declared as character can be used with any character column. The access service library treats TEXT as CHAR or VARCHAR.
Any argument declared as character may be used with any DATE, TIME, or TIMESTAMP column. The value must be in the proper format for the specified datatype.