hi, i am a novice to java I was trying connecting to access mdb file using jdbc. I created a table EMP which had three fields - name(text),descritpion(text),date(date/tim of which name field in which name is primary. I saved the mdb as testmdb.mdb ad had create the system DSN to it.
I had tried to insert a new record with "test" name using my program. Below is an excerpt from my program which i think is causing the problem.
when i am running this program is throwing an error message in the console that there was s data type mismatch in the expression criteria.
i had tried modifying the statement execute line as: s.execute("insert into emp values 'test','','10-nov-2006'");
it worked and i was able to see the record added when i had opened the mdb. I had double checked that the date field was not made as required. Where else can be the problem?
Regards<br />Mutyala Rao Aripaka<br />Bangalore, INDIA