I have checked the SQL string, and it is valid, so its got to be part of the Java code. I am using an Access2000 Database. And popped up a JOptionPane that gave the message: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3. sometimes says Expected 2. I am confused as to what the problem is here? I have done some searches and I have found that it is usually a mis-spelled column name (ie Make would not be in the DB). however I have used the same SQL statement and put it right into Access and it worked fine! I am using VisualAge 2.0, so i stepped through and took the exact sql from the debugger... I know the SQL is fine!