Creating a dataset filled with random records

From: Jenny Yellman (jaquynn_at_ihmail.com.donotspam)
Date: 08/28/04 

Date: Fri, 27 Aug 2004 20:07:02 -0700

I am using VB.NET and creating a dataset that is filled randomly with records
from a table in Access.

The following statement does just what I would like when I test it in
Access. It does not do the same when I use it to configure my dataAdapter in
VB.NET.

SELECT Problem
FROM tblX
WHERE (Skill = ?)
ORDER By Rnd(ID)

Thanks for the help, 

-- 
Jennifer Yellman Quynn
Motivational Assessment