<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=520335413-13042003><FONT face=Arial color=#0000ff size=2>Just
to add to what Lembit's said, Tracy, we found (on the BEU project) that altering
the length of a text field was, frustratingly, a real problem, to the extent
that we opted out of doing it. It can't be done programmatically 9unless someone
can tell me I'm wrong) which leaves creating a new field, copying the data,
deleting the old field and renaming the new one back again. This is all very
well except that if the field is involved in indexes and/or relationships they
have to be recreated too. All very messy. Of course we had the option to just
omit the facility, which doesn't help you much if you have to do it. If you do
manage it, and crack all of those complexities, we'd be very interested to know
how. Sorry to be not much help.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk/">http://www.minstersystems.co.uk</A><BR><BR></FONT></P>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Lembit
Soobik<BR><B>Sent:</B> 13 April 2003 10:57<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD] Alter
Table<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></BODY></HTML>