I would like to ask about primary keys in access. My program creates its keys from the last key in the database. It read the current last key in DB then calculations to come with new key. Problem is when it reaches 100 access sort it and put this 100 under 10. The sequence is ...09,10,11,12. ..99 then sorted to 09,10,100,11... 99. Example key AAA000. Please help