recordset

[sriky]

How can I obtain the first and last values of a field in a recordset.

I am using ADO'S and I can obtain the frist value using rs.movefirst. But I am not able to access the last value. It gives the error

'either BOF or EOF is true. Some of the values may be deleted'. What does this mean?

Please

i used to get this message when i got an out of date recordset, try refreshing the recordset.

[chilakamati]

in a normal single user situation this could happen only if the table is containing deleted records which are not yet purged from the table. Use the Compact database option so that all the deleted records are permanently purged from the table. Then you could use the .MoveFirst and the .MoveLast methods on the recordset. This could also happen if the recordset that you have created is not of the type that is support to do the .MoveLast method.

In a multi-user scenario, this could happen if the same record (last record) is being accessed by another user on the network and has been deleted.