This may be an easy question, but it's been so long since I've dealt with Access that I've been beating my head against the wall trying to get a simple query to work with C#.
The Query is "SELECT # FROM Personnel WHERE (myName = \"Test\") AND (myPassword = \"test\")
I can run the query directly from Access and it returns the row I want, but when I run it through the code, I get the "ODBC Microsoft Access Driver - too few parameters. Expected 1" error.
I'm accessing the database through a DSN.
Any ideas why this will not work?