Newbie Question

[theonetrueace]

i got a login page....and a ms access database....but i only want to allow 1 connection per username....so more than one person cant login on the name at a time...

so ive got a item in my db table thats called "CurrentlyInUse" ... it has Yes/No options enabled....if u look at it...its a checkbox....

so wut i want to do is have it do a check using the session_start function to check if the login name is in use before it allows the user to login.....

since im new to asp, i know exactly wut i want to do...just dont know how to do it.....any help would be great!

thx in advance

AcE

[EyeTalion]

doesn't access automatically lock the DB when it's in use?

[theonetrueace]

yea if its being accessed threw MS Access...i dunno about a direct connection....i need more input...

AcE

[hellswraith]

Why don't you just test it yourself. Create a connection, open it, then create another connection, try to open that. Do some error trapping and see if a error is thrown. I am pretty sure you will get one.