SQL Syntax

You aren't using the UPDATE statement right, check here: http://www.w3schools.com/sql/sql_update.asp

I am still having troubles.  When I hit enter on my form this is what I get

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/updateprofile.asp, line 37

Code: - Line 37 is marked below

<%
Dim strUserName 'Holds the name of the user
Dim userID
Dim adoCon         'Holds the Database Connection Object
Dim rsViewProfile   'Holds the recordset for the records in the database
Dim strSQL          'Holds the SQL query to query the database

'Get the users name passed from the previous page
strUserName = Session("userName")

userID = Session("userID")

'Create an ADO connection object
Set adoCon = Server.CreateObject("ADODB.Connection")

'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("toddwoolums_site.mdb")

strFirstName = Request.Form("txtFirstName")
strLastName = Request.Form("txtLastName")
strHomepage = Request.Form("txtHomepage")
strAim = Request.Form("txtAim")
strLocation = Request.Form("txtLocation")
strInterests = Request.Form("txInterests")

'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "UPDATE tblUsers SET tblUsers.firstname='strFirstName', tblUsers.lastname='strLastName', tblUsers.homepage='strHomepage', tblUsers.aim='strAim', tblUsers.location='strLocation', tblUsers.interests='strInterests' WHERE ID =" & userID

'Open the recordset with the SQL query
Set rsEditProfile = adoCon.Execute(strSQL) --Line 37

'Reset server objects
rsEditProfile.Close
Set rsEditProfile = Nothing
Set adoCon = Nothing
%>

Yet again I found out what that error was.  My session variable needed to me passed to the next page.  It almost works the way I want it too.  The only problem now is that it passes "strFirstName" and not the actual value of the variable.  How can I get it to update with the variable value.

Code

<%
Dim strUserName 'Holds the name of the user
Dim userID
Dim adoCon         'Holds the Database Connection Object
Dim rsViewProfile   'Holds the recordset for the records in the database
Dim strSQL          'Holds the SQL query to query the database

'Get the users name passed from the previous page
strUserName = Session("userName")

userID = Session("userID")

'Create an ADO connection object
Set adoCon = Server.CreateObject("ADODB.Connection")

'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("toddwoolums_site.mdb")

'Create an ADO recordset object
'Set rsEditProfile = Server.CreateObject("ADODB.Recordset")

strFirstName = Request.Form("txtFirstName")
strLastName = Request.Form("txtLastName")
strHomepage = Request.Form("txtHomepage")
strAim = Request.Form("txtAim")
strLocation = Request.Form("txtLocation")
strInterests = Request.Form("txInterests")

'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "UPDATE tblUsers SET tblUsers.firstname='strFirstName', tblUsers.lastname='strLastName', tblUsers.homepage='strHomepage', tblUsers.aim='strAim', tblUsers.location='strLocation', tblUsers.interests='strInterests' WHERE ID =" & userID

'Open the recordset with the SQL query
'rsEditProfile.Open strSQL, adoCon
Set rsEditProfile = adoCon.Execute(strSQL)

'Reset server objects

Set rsEditProfile = Nothing
Set adoCon = Nothing
%>