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?

Andrzej Wegierski · Answer

If I understand You database is not for sorting. If You want to sort database table do it in sql instruction used by DataReader. I don't know about FindLastDate in Framework. An example from VS help: public void ReadMyData(string myConnString) { string mySelectQuery = SELECT OrderID CustomerID FROM Orders ORDER BY 1; OleDbConnection myConnection = new OleDbConnection(myConnString); OleDbCommand myCommand = new OleDbCommand(mySelectQuerymyConnection); myConnection.Open(); OleDbDataReader myReader = myCommand.ExecuteReader(); ... myReader.Close(); myConnection.Close(); } You may to sort table using cluster indexes (in Informix etc. - I don't know about Access)