Could you please advise if there is a table in Access with a lot of columns but without primary key, is there possibility to add? If yes then through which menus?
My target would be to add a kind of autonumber, so the first record should have key 1, the 1000th record should have 1000.
It will automatically start at 1
You can set the primary key status using the "Key" toolbar at the top on your menu's