Help! Expected end of statement

"I am just trying to update the "text" where "line" number = "x".  Does that make sense?"

theres the keyword there... you are trying to "UPDATE" not "INSERT"

so the proper SQL string to run would be like:

strTicker = "UPDATE ticker1 SET [text] = '" & Replace( Request.QueryString("text"),"'","''" ) & "'" WHERE line = " & Cint( Request.QueryString("line")

then

adoCon.Execute( strTicker )

will do the trick, screw all that ADO update stuff....

Note that the above SQL string protects a bit against SQL Injection attacks (search that term on google if you want to know what that's about), and also absolutely assumes that both fields will be on the querystring, if someone doesn't pass a line #, it'll bomb

also note the "[text]", its veeeeery bad practice to use common keywords as field names, especially if you are using Access.....
here's a list of ODBC keywords to avoid like the plague:
http://www.flws.com.au/showusyourcode/codeLib/code/odbc_keywords.asp

Here is what I am getting now.

I am using ljamal's statement

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/lab/test/testTicker.asp, line 35, column 4
"'" WHERE line = " & Cint( Request.QueryString("line"))
---^

<%
'Dimension variables
Dim adoCon    'Holds the Database Connection Object
Dim rsUpdateEntry 'Holds the recordset for the record to be updated
Dim strTicker   'Holds the SQL query for the database

'Create an ADO connection odject
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("ticker.mdb")

'Initialise the strSQL variable with an SQL statement to query the database

strTicker = "UPDATE ticker1 SET [text] = '" &_
Replace( Request.QueryString("TicText"),"'","''" )&_
"'" WHERE line = " & Cint( Request.QueryString("line"))

adoCon.Execute( strTicker )

'rsUpdateEntry.Fields("line") =  request.form("line")
rsUpdateEntry.Fields("text") =  request.form("TicText")

'Reset server objects
rsUpdateEntry.Close
Set rsUpdateEntry = Nothing
Set adoCon = Nothing

'Return to the update select page incase another record needs deleting
Response.Redirect "tAdmin.asp"
%>

aggg...

my head just spins dizzy out of control when i see the utter lack of effort given by some people.......

greaser.. if you are even remotely serious about coding, you have to learn to take a little bit of initive and see what error codes mean..... just a little bit......  after all, the error message POINTS right to where it sees an issue!!  fix it