Go4Expert

Go4Expert (http://www.go4expert.com/)
-   ASP (http://www.go4expert.com/articles/asp-tutorials/)
-   -   Simple Login in ASP using MS Access database (http://www.go4expert.com/articles/simple-login-asp-using-ms-access-t1237/)

ashley 25Nov2008 02:19

Re: Simple Login in ASP using MS Access database
 
This is a great script!

I have a database our sales people use. I'd like to restrict their data to their login; ie. username CD from tblLogin can only see data from tblSales salesID=CD.

Thanks in advance!

ashley 25Nov2008 02:45

Re: Simple Login in ASP using MS Access database
 
I forgot to post how my tables are set up:

tblLogin:
username
name
password

tblSales:
key
salesID

The username from tblLogin will match an entry in salesID, ie. username = CD, salesID = CD.

The login 'admin' needs to access the entire database.

I'm new to programming in asp. I think it's an if statement like if username = "", where username=salesID, then... I'm really not sure though!

kumaaar 26Nov2008 17:44

Re: Simple Login in ASP using MS Access database
 
when i checked the pages its going to the verify page (and showing a blank page of verify )
even if i do any thing with the login parameters.. pls help is thr any mistake in the code..

robinLee01 24Feb2009 01:26

Re: Simple Login in ASP using MS Access database
 
Hi,
I am new to both microsoft access and asp....but i am trying to lerans ways to link a database and a webpage and saw ur codes....i did as u said in the forum...but i wanst sure what to do next... i mean, i have all the three files in one folder, and what next? how would i check if it worked?
Thanks in advance
Robin

shabbir 24Feb2009 09:53

Re: Simple Login in ASP using MS Access database
 
Trying to see them in browsers should be the nest step

Ryan_Wilcox 27Jul2011 12:00

Re: Simple Login in ASP using MS Access database
 
Hi all I need help as I get this error, I am new to asp, and this is for a school assignment.

Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/students/IPT/12IPT2011/007378/Term 3/verify.asp, line 32

Here is my code! (These are the code lines around this area of the error)

'Opening Connection to Database
Conn.open connStr
'Query to be executed
SQLQuery = "select * from tbl_CustomerInfo where Customer_ID = '"&Customer_ID&"' AND Cusotmer_Pass = '"&Password&"'"
'Retrieving recordset by executing SQL
set rs=Conn.execute(SQLQuery)
'If no records retrieved
if rs.BOF and rs.EOF then
Response.Redirect "index.asp?Customer_ID=" & Customer_ID
else

Ryan_Wilcox 27Jul2011 15:15

Re: Simple Login in ASP using MS Access database
 
So sorry for the post, just read over the code myself after getting home, and realised it was a stupid spelling mistake.

Sorry again.


All times are GMT +5.5. The time now is 10:11.