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:
1 2 | CurrentDb.Execute "DROP INDEX PRIMARYKEY ON [table-name]" CurrentDb.Execute "ALTER TABLE [table-name] DROP [key-name]" |