Hello,
I want to use C# to select a random number from MS Access database
table.
<SELECT TOP 1 userID FROM users ORDER BY NEWID()>  seem to work only
with SQL Server.

On Tue, 21 Aug 2007 09:35:12 -0000, dungdang  wrote:

 Hello,
 I want to use C# to select a random number from MS Access database
 table.
 <SELECT TOP 1 userID FROM users ORDER BY NEWID()>  seem to work only
 with SQL Server.

See if the following helps:

http://support.microsoft.com/kb/287682


Paul
~~~~
Microsoft MVP (Visual Basic)