So that we can help you with the SQL conversion where the macro doesn't work, be sure to post the code behind your button.
It might also help to look at the linked table. Access will actually allow a table with not autocounter field to be used. But, if it is upsized into SQL, it will give a warning and continue. But, in SQL Server, the lack of the Identity (autocounter in Access) will cause other problems such as the navigation.
Feel free to provide information and ask questions so we can assist you.
Best of Luck
It might also help to look at the linked table. Access will actually allow a table with not autocounter field to be used. But, if it is upsized into SQL, it will give a warning and continue. But, in SQL Server, the lack of the Identity (autocounter in Access) will cause other problems such as the navigation.
Feel free to provide information and ask questions so we can assist you.
Best of Luck