in reply to Connecting to MS Access

What is the value of $field? It has to be the name of one of the fields (columns) in the table. Did you set it to "field", as in the example? That would be incorrect, and would produce the error you got, unless by chance you also had a column named "field".

Your supposed solution, putting {value} in braces, would not have solved this problem in any case. It's only necessary on property assignment.

A word spoken in Mind will reach its own level, in the objective world, by its own weight