<!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=030440015-13042003><FONT face=Arial color=#0000ff size=2>Adding
or deleting a column yes. But I get syntax error from "ALTER COLUMN" and Help
doesn't recognise it either.</FONT></SPAN></DIV>
<DIV><SPAN class=030440015-13042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=030440015-13042003><FONT face=Arial color=#0000ff size=2>Oh
wait. It's an A97 problem. Works in A2K but not A97, which is pretty much all I
use, so that's my excuse for my ignorance. Well, Tracy, hopefully Susan's solved
it for you. As for BEU, mmmmm...........</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </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>Susan
Harkins<BR><B>Sent:</B> 13 April 2003 15:18<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>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></BLOCKQUOTE></BODY></HTML>