Hi,

>That's the problem. In OleDb, each call is within in its own environment.

Don't think that's true - it *is* true for each connection so you should be able to do something like:

.CommandText = "RAND(-1)"
.ExecuteNonQuery()
.CommandText = "SELECT TOP 10 RAND()....."
.Fill(...)

HTH,
Viv