SQL

[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?

 

[Duane Hookom]

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.