List of Reserved Words for ADO to Access 2000
Posted on 1999-11-03
I've found through trial and error that at least the following three words:
language, translation and position
are reserved words through the ADO Jet4.0 DB Provider. In order to use them, I have to wrap them in [brackets]. I'm writing an app in VB and just stumbled across this as I upgraded my references to Access2000. I'm wondering if there is a list anywhere (couldn't find anything on MS site) of other newly reserved words (which, incidentally, do not appear in the reserved word listing for Access, and are valid column names) that ADO is going to have a problem with....
Or should I pass every SQL statement through a routine that turns EVERY column into [ColumnName] for Access?