hey guys i was wondering if you help me out with this problem of mine basically am trying to add to my Access database and it keeps throwing an error and cant find out why the error is as follows

Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/marking/stylespages/regprocess.asp, line 20

My Code
<%@ Language ="VBScript"%>
<%
'declare local variables
Dim Connection, addrecordset
Dim strSQL, sConnString
'declare SQL statement that will query the database
'define the connection string, specify database
'driver and the location of database
sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("..\database\heas.mdb")

'create an ADO connection and recordset
Set connection = Server.CreateObject("ADODB.Connection")
Set addrecordset = Server.CreateObject("ADODB.Recordset")
connection.Mode = 3 ' adModeReadWrite
connection.Open sConnString
strSQL="SELECT staff.Staff_ID, staff.Staff_Password, staff.First_Name, staff.Staff_Last_Name, staff.Email_Address FROM staff;"
addrecordset.Open strSQL, connection, 1, 3

'allow the addition of new records to the database
addrecordset.AddNew
addrecordset.Fields("Staff_ID") =Request.Form("Firstname")
addrecordset.Fields("Staff_Password") =Request.Form("Lastname")
addrecordset.Fields("Staff_First_Name") =Request.Form("StaffID")
addrecordset.Fields("Staff_Last_Name") =Request.Form("Password")
addrecordset.Fields("Staff_Email_Address") =Request.Form("Email")
'allow the update procedure
addrecordset.Update
'close recordset and connection freeing up server resources
addrecordset.Close
Set addrecordset = Nothing
Set connection = Nothing
'redirect to account confirmation of account creation
Response.Redirect"accountcre.asp"
%>

Any feedback is appreciated thanks...
Chris

__________________
in opposite world i love programming

Which is line 20???

By my count of that code, it looks like it's *probably* this line:
addrecordset.Open strSQL, connection, 1, 3

Yes?

So have you tested that SQL code in Access??

Are you sure the field names there all exist and are spelled correctly?

If that's not the culprit line 20, then which line *is* line 20??

Look at this:
And then compare it to this:
ONE of those is clearly wrong. I'm betting on the SELECT.

You know, there is NO REASON to use "tablename.fieldname" instead of just "fieldname" when there is only one tablename in the query.

So you could have coded that as
(assuming my guess as to the culprit is correct).