Yes you are right it was a bad field name. Someone who was helping me create the Access DB renamed the column name slightly and although I had read in many articles that the error I was getting was probably due to a bad field name, and I checked may times, I missed it! So frustrating!
Anyhow thanks all for your assistance.
Marcus