Search:

The second query looks like it needs a WHERE in order to join the tables (see your original query syntax). The first may be an issue with selecting too few parameters (eg you select 3 but try to...

Not sure what combQ is :confused:

Did you change the variable names, and did this solve your problem?

Nevermind...simple solution which I can't believe I overlooked...

Check your ResultSet variables...so this was a java problem after all ;)


ResultSet aminoMolWtRS =...

I've never used Access, so cannot point you in the direction of a low level interface. Let's step back for a second...your original post, on what line was the exception being thrown?

As for the command line interface, most databases I've worked with all have some sort of utility that allows access to the database via the command line. I'd suggest trying to a) see if you have one...

This is more of an SQL and not java...nevertheless:
1) Can you execute the query using a command line interface to the database without a problem? This is always the best way to get a feel for the...