[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