SORTING ACCESS TABLE FROM VISUAL BASIC APPLICATION

I developed a Library Management Project using Visual Basic 6.0 and Access database. I use ADODC.
I wish to sort all of the books in the database in the ascending order of BookId. For this, I placed
a button which have the caption property “SORT”. I
mean when click on this button, the entire books are sorted by ascending order of bookid within the database. How can I do it?… Can you give me an example code?