It seems there is a clear trend that newer versions of Windows and MS Office manage to just wreck fundamental functionality rather than enhance it with newer versions. I was just working on a simple APPEND query in Access a while ago. Access 2007 returns an obscure error: “INSERT INTO statement contain unknown field name” error. Access 2003 runs the same exact query without problems. There was nothing fancy in the query I was doing. It was just a very simple append operation but Access 2007 just won’t run. I did research the error a bit and did not find any satisfactory solution.