I've got a 'disconnected' recordset (in truth it was never, and won't be,

connected to anything) and I'm working in VB Professional not ASP (but

that's by-the-bye).  I have created a field called ID:



  With rsTfrUp

    .CursorLocation = adUseClient

    With .Fields

      .Append "ID", adInteger, , adFldKeyColumn + adFldRowID



...



I expected this to mean that when I .addnew I will get the next number in

sequence in the ID field.  This doesn't seem to be the case.  Anyone else

have luck with this?  I am resorting to having a variable in my object that

fulfils this function.  Remember that the recordset is completely

freestanding.