<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Verdana size=2>Hi Listers</FONT></DIV>
<DIV><FONT face=Verdana size=2>I'm trying to alter a Access table via code, I've
tried the following:</FONT></DIV>
<DIV><FONT face=Verdana size=2> dbs.Execute "ALTER TABLE
[JobsOutwork] ADD COLUMN LP_Description Text (250);"</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>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.</FONT></DIV>
<DIV><FONT face=Verdana size=2>Is there any programatic way to alter an existing
table/field ?</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>Any help appreciated.</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>Cheers Tracy</FONT></DIV>
<DIV><FONT face=Verdana size=2> </DIV>
<DIV><BR></DIV></FONT></BODY></HTML>