<!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.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Well, you'd need ALTER COLUMN:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>dbs.Execute "ALTER TABLE JobsOutwork ALTER COLUMN
LP_Description Text (250);"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Although, I can't guarantee it'll work with
.Execute -- </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Susan H. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT><BR> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial size=2>Tracy,</FONT></DIV>
<DIV><FONT face=Arial size=2>AFAIR you cannot modify a field. you need to
create a new field and copy the data to the new field. code, how to do this
can be found in our famous BEU project. go to our webside download page and
download the BEU.</FONT></DIV>
<DIV><FONT face=Arial size=2>Lembit</FONT></DIV>
<DIV> </DIV>
<DIV>Lembit Soobik<BR></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=tracy@ak.planet.gen.nz
href="mailto:tracy@ak.planet.gen.nz">Tracy</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, April 13, 2003 10:04
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Alter Table</DIV>
<DIV><BR></DIV>
<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>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>