Database - strange error

Question

I update a Access database by inserting new records which I want sorted by date. They get added at the end so I have do go in and sort them descending to move them up top. I save the database, close it, and reopen it days later. I use my DataReader FindLastDate() function at it shows the same new dates still at the bottom! Why is this? Is there a way to sort a database automatically or permanently? Is there a way I can insert my records at the top?

Answer 1

http://demo.passguide.com/download/VCP-410.zip