Some of my tables have no key since auto-number won't ensure no duplicates are entered.
Other tables have multiple fields as key because this is the only way to uniquely identify.
Migration did not like certain tables or queries due to this, are keys required?
Also my Forms and queries in Access would not allow changes I assume due to "Key" issues.
Can someone please parse out the basic criteria for me?