[AccessD] Autonumber Assigned Immediately

Either way -- sounds like reasons for routine backups and not a reason to
not use a feature. 

OK, now who wants to talk about lookup fields???????????? <jk> 

Susan H. 

Yes, it absolutely is, and equally possible (and likely) to scramble the
data in the field that you are using for part (or all) of a natural key.