Login from Table works, not from Query

Hi,

This is a very strange problem.

SA works well when I'm checking the username and password from a ms access database. But not when I access those field from a database query.

Has anyone had the same issue ?
I'm using ASP/VbScript.

Thanks

I have used Access queries with Security Assist before without a problem. Are you 100% certain the user you are trying to login with is being returned by the query?

Yes. I have even tested with a new query also where only the contact table is included.
All the fields and users are returned by the query.

I have a feeling that the form values are not sent are received properly when using a query in access.

The error I get is:

Runtimefout Microsoft VBScript error '800a005e'
invalid use of Null: 'cStr'

This error means that one of the values being compared is a NULL Value. Most likely one of the Columns you selected to be stored in session variables. make sure there are no NULL Values in the columns you select to store in session variables.

yes, that is it. The query contains also other that do not require to login and have no password set.

thanks for your help !