SQL

  • Thread starter Thread starter Simeon Hearring
  • Start date Start date
S

Simeon Hearring

I'm using Java to connect and query from an Access 2000
database. One of the Access queries I'm attempting to
SELECT from references an Access form for some data. When
I run the class, I get the following error:

SmartDBUtilMSAccess: Error while trying to do the query
java.sql.SQLException: [Microsoft][ODBC Microsoft Access
Driver] Too few parameters. Expected 1.

Is there a way to pass the value the query is looking for
on the Access form from the SQL string in the java class?
 
One work around is to use a one record table to store the criteria value.
You can then add the table to the query and place the field in the query.
 
Back
Top