>When I run this code;

oCommand = CREATEOBJECT("ADODB.Command")

cCommandString = "insert into bspotln (docid, boid) values (" +;
TRANSFORM(nDocId) + "," + TRANSFORM(nNewId) +")"

WITH oCommand
  .CommandText 			= cCommandString
  .ActiveConnection 	= This.oConnection
  .CommandType 			= adCmdText
ENDWITH

oCommand.Execute

>I get the error "Field 'xyz' does not accept null values". Is there a way
>to override this or turn it off? I dont want to have to fill in ALL the
>fields to add a record.

You could add the NULL flag to all the fields in the table. Is xyz a normal field, or a primary key?