[AccessD] Change Field Size

Bryan Carbonnell carbonnb at gmail.com
Mon Dec 5 19:13:31 CST 2005


On 05/12/05, Reuben Cummings <reuben at gfconsultants.com> wrote:
> 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).

I've done it too. I even used the BEU to fully normalize a BE that had
been in use for about 3 years without any problems. A LOT of mods,
well over 200, but it was a completely new BE when the BEU was done.


--
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"



More information about the AccessD mailing list