I am trying to rename a column in my table and I keep on getting a syntax error message. This is very annoying since I have been sitting on this problem for ages now and I just cannot see what I am doing wrong!!!!!
I think there is an error with MSDN. I have had trouble with other MS sites today. Google for "Jet Intermediate SQL". Use the Cached version. There are also Basic and Advanced SQL documents. They are excellent.
It might seem rather obvious now, but fabricating your own syntax and then spending a day "debugging" it is not going to get yourself anywhere very fast. I know the syntax looks sensible enough but it's not any use if the application doesn't recognise it.
Anyway, you know the docs to refer to now for JET DDL.