text: recordset.addnew doenst work with my ms sql server...? hi, i m trying to run the command recordset.addnew but it doent work on my server when it is working on my local computer... can anyone help me with this... i will be thankful to this... be sure to check the types of parameters you are using to open up the recordset. you will need to use adopendynamic  and adlockoptomistic for your locktype. (might need adlockbatchoptomistic if youa re doing a batch)