[AccessD] Change Field Size

Sorry, Gary.  I've been out of town a lot.

We have discussed it and to say the BEU can't do it isn't completely correct
(Sorry, Andy).  It can't do it in one step.  The code that was discussed
doesn't even do it in one step.  A new feild has to be created with the
proper size, the data moved, the orginal field deleted and the new field
renamed.  The code simply automates some of these steps.

I've done it several times using the BEU and it's worked perfectly, but it
takes a minimum of 4 mods (more if you have to handle indexes and
relations).

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gary Kjos
> Sent: Monday, December 05, 2005 12:48 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Change Field Size
>
>
> I was wondering why you guys weren't jumping in there. Thanks for the
> clarification Andy.
>
> Gary
>
> On 12/5/05, Andy Lacey <andy at minstersystems.co.uk> wrote:
> > Thx for the plug Gary but in fact changing a field length is
> not available
> > in BEU (yet). It wasn't in because, like changing field type,
> you can't do
> > it straightforwardly with DAO code and ALTER COLUMN doesn't work in all
> > versions (not in A97 certainly). As it happens we're currently
> looking at a
> > v2 of BEU and one of the features we're hoping to incorporate is this.
> >
> > --
> > Andy Lacey
> > http://www.minstersystems.co.uk
> >
>
> --
> Gary Kjos
> garykjos at gmail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>