Bill,<BR><BR>I tried your code but it&#039s giving me syntax error on the UPDATE statement. This is what was happening before when I tried this approach...<BR><BR>I can&#039t spot anything obviously wrong, but there must be...<BR><BR>Oh yes, I should let you know that there could be multiple records matching this query which need updated (if that makes a difference).<BR><BR>&#060;% <BR>OrderID = Session("OrderID") <BR>SVCustID = Session("SVCustID") <BR><BR>&#039 Establish a connection <BR>dim connection <BR>set connection = server.createobject("adodb.connection") <BR>connection.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=d:websiteCustDB.mdb" <BR><BR>SQL = "UPDATE Cart SET CustNo=" & SVCustID & " WHERE OrderID=" & OrderID <BR>connection.Execute( SQL ) <BR>%&#062; <BR><BR>Thanks