Select Random Number from Access Table Using C#

  • Thread starter Thread starter dungdang
  • Start date Start date
D

dungdang

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.
 
¤ 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)
 
Back
Top