MS Access allows reserved words as field names (!)

afarr

I have just spent a couple of hours looking into (or rather, overlooking) an SQL error, while trying to export from Navision to MS Access. I finally realised that the error was due to a field in our client's database called "Order" - this is a reserved word in SQL, but MS Access still let them use it as a field name, leading to wonderful errors when you try to use the field in an SQL statement.

I thought it might happen to you too, so you might as well be prepared.

Waldo

When you put "[" and "]" around the field name, this should be resolved, no?

afarr

Yes, it does. Thanks for telling me about that.

Alastair