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?
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.