Error message

[augean]

hi all ,

I need to know what doest this error message means :

Data type mismatch in criteria expression.


so I'll know where I look for my mistake :)

Thank you

[skriptkiddie]

I found this. Hope it helps.


Question:

I receive the following error message when trying to save changes I made to database:


Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/tablename_edit.asp, line xxx




Answer:

Issue

The SQL error 80040E07 occurs when attempting to use the "Insert Record" or the "Update Record" server behavior to set the value of a column in Microsoft Access with an empty string ("").


Reason

MS Access is characterized by strong data typing; it imposes a rigorous set of rules on given column values. The empty string value in the command text (SQL) cannot be stored in MS Access' "Date/Time" data type specified by the associated column.


Solution

Try to avoid inserting and/or updating columns of "Date/Time" data types in Access with empty strings, ("") or with any other value that does not correspond to the range of values specified for the data type.

[augean]

Thank you for your information
but all I need is Reading from a DB ,
I don't know why , but I have almost the same code in dofferent site , and it works over there , but not here !!!!

is there any other help ?

~Augean

[augean]

I found the error .

there was a problem at my DB .

Thank you

~Augean