Authenticate user - HTTP/1.1 500 Server Error

[Sally_C1]

When using Authenticate User behavior I get HTTP/1.1 500 Server Error. Only on remote server, not localhost. The host first tried to tell me it was because I was using Access, that my db wasn't working, but I showed them that it did work on pages without the behavior. I feel like I'm getting the runaround. Anyone else have this problem? Any ideas on how to help would be greatly appreciated.
Thanks.
Sally

[Sally_C1]

I just realized that when the login page is submitted, not only is the page not going to the "if succeeds" page, the directory name the domain name points to appears after the domain name- i.e. http://mydomain.com/mydomain/Residents_LogIn2.asp. This is the URL that is giving the 500 error. The page is not going to http://mydomain.com/directory2.asp.

On my local server it goes to http://localhost/mydomain/directory2.asp

I can't see anything in the code that would cause this, but I will attach it. I don't know if this makes a difference, but the hosting site allows multiple domains to be hosted on your server space, you just point what directory you want your domain to point to on your server. So http://mydomain.com points to the "mydomain" directory. But the file is submitting to htdocs/mydomain/mydomain/Residents_LogIn2.asp All the other pages - including the dynamic ones updating and inserting records - work fine. It's just the one with the Log In User behavior.

I would appreciate ANY suggestions as I am totally stuck.