Data type mismatch MS Access autonumber field
843859May 16 2007 — edited May 16 2007Hi, im trying to delete a rec from Access from java code.
My SQL is: String query = "Delete from items where item_id='"+dbitem_id+"'";
Where dbitem_id is a Double variable.
Item_id in Access is a autonumber longinteger
Im getting [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. when I run it.
Any idea how I can fix this?
thanks.
Jason