To delete the ID field that Access creates automatically for a new table, the table must appear in Layout view rather than Datasheet view.

Name: To delete the ID field that Access creates automatically for a new table, the table must appear in Layout view rather than Datasheet view.
Brand: Quizplus
Rating: 4.9 (36 reviews)

Question

Quizplus · Accepted Answer

In Access, you can delete the ID field in Datasheet view by selecting the column and pressing the delete key. Layout view is not necessary for this action.

To Delete the ID Field That Access Creates Automatically for a New