How do you name a field with a reserved keyword in Access 2007?

Question

I'm sure you will say this is bad, but sometimes it is necessary. In Sql Server, you just put [brackets] around the field name.

Is it possible to do this in Access?

squillman · Answer 1 · 2010-01-07 02:17:24Z

up vote 0 down vote

SQL reserved word you mean? It works for me by just typing it into the designer.

answered Jan 7 '10 at 2:17

squillman
3,74011026

	oh I guess I got tripped up by the warning.. It actually says "This may cause problems when you try to query later.." – KevinDeus Jan 7 '10 at 2:37
	This is really a comment, not an answer to the question. Please use "add comment" to leave feedback for the author. – Diogo Aug 9 '12 at 13:33

1 Answer