look if file file exists before process

Check this for inspiration:

http://www.w3schools.com/asp/met_fileexists.asp

hi Admin,

your post was really really helpful and fix a lot of my issues, however, I found out that the database connection needs to be set on BEFORE PROCESS witch make an almost impossible task to select the DB on BEFORE LOGIN.
this bring me to the following question

can be a way to fully login over URL without get to login page and press SUBMIT?

i can transfer everything over URL, the username, password and database name but i can't do the login.
i try: myweb.com/login.asp?username=gonzalo&password=sb&btnSubmit=login but nothing,
that fill out the information on username and password but not click on SUBMIT so i send it over URL but get stock on login.asp page
also try THIS POST but looks like is set for SQL and im using MSACCESS and give me an error.
any help on this?
thank you

That post has nothing SQL Server specific and should work with MS Access. You just need to make sure you build a proper SQL query.

i have this error using the code for URL login

any idea?
is anything else i need to change beside the database name?

You need to print your query on the page instead of executing it to see what exactly is wrong.

How can i do that???

Assuming that SQL query is in variable named strSQL you can do this:

hi Admin,

thank you for your help and this forums that are AWESOME.
I found the way to select the database before log in without an error after as i mention in the beginning so is no need of transferring via URL, and even do never work for me, I will e really interested in see it working.
if someone need help on this let me know.