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