
February 10th, 2004, 09:42 AM
|
|
Registered User
|
|
Join Date: Jan 2004
Location: england
Posts: 18
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
creating a password with MDB
Ineed to create password access to a site.The usernames and passwords will be stored on a MDB so when the person logs on if the password is incorrect they will be redirected to a error page . If they are successful they will enter the site.
How do I do this?
my script will use the following connection method to the database
<%sql="select * from users where usename like '%"&username&"%' AND pass like '%"&pass&"%'"
Set OBJdbConnection = Server.CreateObject("ADODB.Connection")
OBJdbConnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=e:\users\names.mdb"
Set RS=OBJdbConnection.Execute(sql)%>
|