Quote Originally Posted by si_the_geek View Post
The problem is probably due to one of your field names (probably password, and maybe more) being a reserved word, and as such should not be used as a field/table name (it confuses the query parser within the database system).

If you change the name (in the database and your code), it is likely to work correctly.

For more information (including lists of Reserved words), see the article What names should I NOT use for tables/fields/views/stored procedures/...? from our Database Development FAQs/Tutorials (at the top of the Database Development forum)
si_the_geek you are a LIFE SAVER!

I changed the "Password" field to "Customer_Password" and it works perfectly!

Thanks so much!

Dave