ALTER TABLE query syntax error

[Sck]

I am trying to run an a

ALTER TABLE query via currentdb.execute sql, dbfailonError



sql =

ALTER TABLECopy_tblExportformat_Base_Monthly ADD COLUMN Jun-18 Long NOT NULL

this fails with Err Number 3292 Description Syntax error in field definition

if I change the sql to either of these:

sql = ALTER TABLECopy_tblExportformat_Base_Monthly ADD COLUMN Jun18 Long NOT NULL
sql = ALTER TABLECopy_tblExportformat_Base_Monthly ADD COLUMN 'Jun-18' Long NOT NULL

it runs but I need the field name to be Jun-18 to match up with a Corporate system.

thoughts/assistance?

[pbaldy]

Untested, but try bracketing the field name: [Jun-18]

[Sck]

perfect!! don't know why [ ] didn't register with me as the fix...… THANKS!

[pbaldy]

Happy to help! The brackets are usually the workaround when you have inadvisable spaces or symbols in an object name.