Joel

Hi,

I Redim An array based on the value of (.RecordCount - 1) When I .AddNew &
.Update it increments the value of .RecordCount Which screws up the logic of
the application (it assumes the max value of the subscript was the original
value of (.RecordCount - 1). Question: It seems the other Db (Connx ODBC
for Dataflex DB) worked differently the value of .RecordCount remained the
same even when adding new records.

Can there be a reason for all this?

PS I Set the RecordSet to: .CursorLocation = adUseClient