I have a Windows 10, Access 2016 DB with a weird issue.
I have a table named PM Tasks with the following properties.
[IMG]file:///C:/Users/tom/AppData/Local/Temp/msohtmlclip1/01/clip_image002.jpg[/IMG]
I want to append some records to this table, and have the following query to do so.
Code:
INSERT INTO PMTasks ( EquipmentKey, MaintenanceCycle, AssignedResponsibility, Source, PMInstruction, Comment, PMTaskName, CreationDate )
SELECT PMTasksTemp.EquipmentKey, PMTasksTemp.MaintenanceCycle, PMTasksTemp.AssignedResponsibility, PMTasksTemp.Source, PMTasksTemp.PMInstruction, PMTasksTemp.Comment, PMTasksTemp.PMTaskName, PMTasksTemp.CreationDaste
FROM PMTasksTemp;
When I run the above append query, I get the following error.
[IMG]file:///C:/Users/tom/AppData/Local/Temp/msohtmlclip1/01/clip_image004.jpg[/IMG]
The Primary key is KEY, a auto number field, which as I understand it, should be automatically numbered by the append query. I do not understand why there would be key violations here.
Can anyone help me with this?