The following tips might help you prevent problems while scripting.
RecordCount
, which is documented as returning the number of records affected by a statement. However, the value returned in this property depends on the database. Microsoft SQL Server does not return a useful value in this property in certain cases, so you should not rely on it in your script. Instead, you should check RecordSet.EOF
, using script such as the following:Do While Not RecordSet.EOF ' Process here RecordSet.MoveNext Loop
© 1997 by Microsoft Corporation. All rights reserved.