[AccessD] Alter Table

Hi Listers
I'm trying to alter a Access table via code, I've tried the following:
  dbs.Execute "ALTER TABLE [JobsOutwork] ADD COLUMN LP_Description Text (250);"

I'm trying to alter the field: LP_Description from being a text field of 100 characters to a text field of 250 characters, using the above line - generates the error message that the field already exists.
Is there any programatic way to alter an existing table/field ?

Any help appreciated.

Cheers Tracy


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030413/143c4eb6/attachment.html>