Hello!

VB Code:
  1. rs.Open "SELECT * FROM Customers", cn, adOpenKeyset, adLockOptimistic

The recordset opens just fine and allows me to .Addnew
Also, rs.EOF is false

So why does rs.Recordcount return a -1 when that recordset actually contains records?

Could it be some permissions problem with my SQL server SA account?

Thanks in advance!