title: Access Database Automatically sorting records! How to stop?
body: <p>i am building a program that uses a database.</p>
  
  <p>When i enter my data into the database it doesnt stay as entered. It is automatically sorted into ascending order by a field that contains the ID number. The problem is when i create a new record programatically, it creates a record in another table with the same row number.</p>
  
  <p>I need to stop access automatically sorting the records. any ideas?</p>