Out of place means that the " is does not fall at the correct position in the string.

For example: Response.Write("This is a strin"g)

Would generate the same error that you are getting: Unterminated String constant. In the above example the 2nd " is out of place as it should encompass the entire string do doing this:

Response.Write("This is a string")

Corrects the error.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Okay, I've simplifed the string as much as possible to this:

set rsInsert = conn.Execute ("INSERT INTO user (lastname) values ('" & lastname & "')")

It appears there are matching parens and single, double quotes. What am I missing here? I'm being dense obviously.

This looks correct and it should have cleared up the Unterminated string contant error. If you are still recieving problems what value does the variable lastname contain?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Here's the latest error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'user'.

Write out your sql statement. What is its literal value?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Come again? Refer back to being dense.

Refer to my second post about how to write out your sql statement. This will give you its literal value.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

This is what the response.write returns:

INSERT INTO user (lastname) values (' ')

User is a reserved keyword in TSQL (MSSQL Server anyway) and you need to reference it like this: INSERT INTO [user](column) values(value)

Also, it is a good idea to refrain from nameing tables and columns that use SQL Keywords if for no other reason, to avoid these types of situations.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Makes sense and I should have thought of that. Fixed that problem, but no data is getting inserted into the table. Here's the lastest response.write:

INSERT INTO usertbl (lastname) values (' ')