Vista - vbscript to alter table in msaccess

I have am trying to update two tables one updates just fine but for
some reason I get an error on the other. Anyway ideas what going on
would be helpful. The script is dying at this line
"objAccess.DoCmd.RunSQL "ALTER TABLE image ALTER COLUMN COMMENT TEXT
(40)".

Error below:

Windows Script Host

Script: C:\myfolder\script.vbs
Line: 10
Char: 1
Error: Syntax error in ALTER TABLE statement.
Code: 800A0CDD
Source: (null)



Srcipt below:


Set objAccess = CreateObject("Access.Application")

objAccess.AutomationSecurity = 1 ' msoAutomationSecurityLow

objAccess.OpenCurrentDatabase "C:\mydatabase.mdb"
Set db = objAccess.CurrentDB

objAccess.DoCmd.RunSQL "ALTER TABLE mytable ALTER COLUMN FILE TEXT
(50)"
objAccess.DoCmd.RunSQL "ALTER TABLE mytable ALTER COLUMN FILE TEXT
(50)"
objAccess.DoCmd.RunSQL "ALTER TABLE image ALTER COLUMN COMMENT TEXT
(40)"

objAccess.AutomationSecurity = 2 ' reset

On Jun 5, 9:12 am, jago...@xxxxxx wrote:"image" is a data type in SQL. Try enclosing it in brackets [image] so
it is parsed properly as a table name rather than a data type.

Hi Jason,

Thank you for the help. It is always the little things. All is
running smoothly now.


Jay

Jay wrote:Don't use "image", or any other reserved keyword, as an object name - it
will bite you in the behind sooner or later.
--
HTH,
Bob Barrows

Thank you Bob. Issues do come up when you are not paying attention.


Jay.