I'm pretty sure you can use the brackets around the column name in
queries from Access tables also. Not so sure how far this fix would go
though--updates to the tables, etc.?
If it were me, I'd require them to rework to avoid the reserved words.
That's just plain bad practice.
It would not be
An organization I work with recently hired a firm to redo their website.
This includes both HTML and CF.
A problem cropped up on a portion of the work. I looked at their code
and found they were using reserved words for field names, e.g. Year.
The query worked when I pulled it out and plugged it
Larry,
I am not trying to criticize the institution or the client or to reiterate
the rhetoric that Access just simply is a troubled solution.
As for the reserved word usage, that just needs to be changed to avoid the
exact issue you are having. It is a reserved word on purpose.
With Access, I
What part of the word RESERVED do they not grasp?RESERVED means it's
RESERVED for a specific use.
When you go to a concert, and sit in a seat marked RESERVED you can expect
that it's odds-on there's gonna be trouble, unless it's reserved for you.
This is no different.
The solution is for
4 matches
Mail list logo