View Single Post
  #2  
Old 12-14-2010, 10:36 AM
Norrit Norrit is offline
Moderator
 
Join Date: Aug 2001
Location: Landgraaf
Posts: 7,333
Default

Don't know Access (I know, but never worked with it).

In MSSQL there's a method called ROW_NUMBER()
perhaps this is also available in Access...

Easiest to gain speed is to fetch only the columns you're showing... For example, in a grid you don't display columns of type VARCHAR(max)...
Reply With Quote