[AccessD] Edit Field Property via Code

...thanks Andy ...I hadn't run into anything BEU couldn't do so made the
assumption ...which only goes to prove the old adage ...at least about me :(

William Hindman
Government is not reason, government is not persuasion,
government is force. It is a dangerous servant." G. Washington

----- Original Message ----- 
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, December 03, 2003 8:03 AM
Subject: Re: [AccessD] Edit Field Property via Code


> Your faith in BEU is touching William. Unfortunately, as you'll see in my
> response to Selina, extending field lengths is one of the very, very tiny
> number of things that BEU doesn't do. Make the coffee....yes sir. Wash the
> floor....no problem. Take the kids to school......BEU's the boy. Extend a
> character field's length......sorry, no can do. :-(
>
> The problem is that there's no way to do it with code. ALTER TABLE offers
a
> solution but it's not in A97. When we get round to a new version of BEU
it's
> on our list of things to address, but the best we're going to manage is
> allowing it in A2K onwards.
>
> And before anyone suggests creating a new field, querying all the old data
> into it, deleting old field, renaming new one - yes we know, but consider
> the situation where the existing field takes part in indexes and
> relationships. Then consider a table which already has its maximum number
of
> indexes so you can't define the same indexes on the new field even if you
> want to. Not so easy, and very dangerous to be playing around with
someone's
> data like that.
>
> --
> Andy Lacey
> http://www.minstersystems.co.uk
>
>
>
>
> --------- Original Message --------
> From: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Edit Field Property via Code
> Date: 03/12/03 18:34
>
>
> Selina
>
> .... http://www.databaseadvisors.com/downloads.htm ...the home for this
> list,
> has a download available that shows you how to do that ...look for the
> Backend Upgrader (BEU). ...HTH :)
>
> William Hindman
> Government is not reason, government is not persuasion,
> government is force. It is a dangerous servant." G. Washington
>
> ----- Original Message -----
> From: "Selina Iddon" <selina at easydatabases.com.au>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Wednesday, December 03, 2003 8:06 AM
> Subject: [AccessD] Edit Field Property via Code
>
>
> > Good Evening Everyone
> > I have several databases being used across town and I need to send out
an
> > update which will increase an existing text field size 15 characters to
be
> > 25 characters. I can add fields, but cannot figure out how to edit them.
> > If someone could help I would truely appreciate it.
> > Thanks heaps
> > Selina
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> ________________________________________________
> Message sent using UebiMiau 2.7.2
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>