hi
       I am using C# as the language for programming .I am accessing table in the access database . The table has three fields EmpName(text), FromDate(DateTime) and ToDate(DateTime). I am getting error while executing reader .

The Query string is
SELECT * FROM EmpLeaveApproved WHERE EmpName LIKE 'Akhil Vira' AND FromDate BETWEEN '1/1/1999' AND '1/1/2000';

The error message that i am getting is
Data type mismatch in criteria expression.

Can anybody please point out were i am making mistake
Thanks in advance

Regards
Akhil Vira

I will add the code that is getting caught .




strQuery = "SELECT * FROM EmpLeaveApproved WHERE EmpName LIKE '"+strEmpName+"' AND FromDate BETWEEN '"+date.ToShortDateString()+"' AND '"+ date.AddYears(1).ToShortDateString()+"';";
                OleDbConnection conn= null;
                OleDbDataReader reader = null;

                conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; "+
                        "Data Source=" + Server.MapPath("Data/leaverecord.mdb"));
                conn.Open();
                OleDbCommand cmd = new OleDbCommand(strQuery,conn);
                reader = cmd.ExecuteReader();



it is caught in catch when it executes cm.ExecuteReader.

Hi,
I suppose the problem is with query string....

SELECT * FROM EmpLeaveApproved WHERE EmpName LIKE 'Akhil Vira' AND FromDate BETWEEN #1/1/1999# AND #1/1/2000#

this query works well and good
just try with this sysntax...just replace ur "'" with "#"...
hope this will do
regds
rahman

thanks rehman_reck it worked .
U were really helpful
Thank u very much

Regards
Akhil Vira