I have a M$ Access 2K DB which has a single table and a query saved in it.

The Query Starts SELECT * FROM MyTable but goes on to add a "new" field using RND() seeded with the Now() and [id].

The same SQL is used directly in my ASP page.

If I access the Query or create a connection to the table using the SQL the result is the same. If I connect again and do the same the result is still the same.

It should be different as I am ordering by the RND col.

I'm useing Microsoft.Jet.OLEDB.4.0 (if it makes any difference) and I want to know if anyone knows a way to slap a RANDOMIZE instruction on the DB to "refresh" the RND order of rows.