Question Retrieve a random column data from MS-ACCESS

[arvindmewara]

hello all ,
i want to generate random question for my application which i will show on my quiz form.
everytime when user start application it will show question in random order(sequence should be different).
i using ms access database,


Dim adp As New OleDbDataAdapter("select * from exam where sno = (SELECT CAST(rand() * count(*) as int) + 1 from exam)", con)

i try above code for random question generation but i m getting this error:

IERROINFO.GETDESCRIPTION failed with E_FAIL(0*80004005)

thanks