Access doesn't use record numbers in the sense that ISAM files such as dbase did. Relational databases are unordered sets so by definition, sequence has no meaning.
If you have a need to track the order in which rows are added to a table, use an autonumber column or a date/time stamp and sort by whichever you choose when you create a query to retrieve rows.
