VBA: SQL statement to remove Primary Key from Microsoft Access table

History:

In microsoft access a primary key is an index with name PRIMARYKEY (one word)

How to remove:

CurrentDb.Execute "DROP INDEX PRIMARYKEY ON [table-name]"
CurrentDb.Execute "ALTER TABLE [table-name] DROP [key-name]"