Using MS Access 2007 GUI, I created an append Query, as I always have since version 2003, where I am trying to append records froma a temporary to a master table, all fields match, and keep getting the message:
The INSERT INTO statement contains the following unknown field name: <field name>. Make sure you have typed the name correctly, and try the operation again.(Error 3127)
In this case the field name is [Program], in both tables. However, it dosn't seem to matter as I've tried this with other append queries since I upgraded to 2007 and have the same problem. MS Access created the SQL code, as I usually let it do.
Has something in 2007 changed this process or is this a bug?
(I apologize ahead of time in case I have posted this in the wrong forum.)
Changed typeYichun FengMonday, April 06, 2009 3:45 AMDon't follow up in three days
We are changing the issue type to “Comment” because you have not followed up with the necessary information. If you have more time to look at the issue and provide more information, please feel free to change the issue type back to “Question” by editing your initial post and changing the radio button at the top of the post editor window. If the issue is resolved, we will appreciate it if you can share the solution so that the answer can be found and used by other community members having similar questions.