TOP 5 in access db

  • Thread starter Thread starter Brian Henry
  • Start date Start date
B

Brian Henry

how do you get the TOP clause to work in ADO.NET? I have tried this SELECT
TOP 1 NOTE FROM NOTES and that works, but soon as i raise the number past 1
it gives me the entire table back! I want the top 5 records not all of them,
how do you get this to work in ado.net with an access db.. thanks!
 
¤ how do you get the TOP clause to work in ADO.NET? I have tried this SELECT
¤ TOP 1 NOTE FROM NOTES and that works, but soon as i raise the number past 1
¤ it gives me the entire table back! I want the top 5 records not all of them,
¤ how do you get this to work in ado.net with an access db.. thanks!
¤

I can't repro this behavior. Are you using the Jet OLEDB provider?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top