[AccessD] Development Cycle BE Question

On 17/01/06, Joe Hecht <jmhecht at earthlink.net> wrote:
> So this will take one table and slice it to about 8, with
> the correct fields and rename them each time?

It will do that, but you have to tell it to.

The steps you would tell the BEU to do, in a very general sense are:

Create the table(s)
Add the fields to the new table
Copy the data from the old to the new
Delete the old table when everything is done.

> What happens to queries while tables are being redone?

Nothing. The queries stay untouched. You will need to recreate the
queries in the FE once the table structure(s) have been
updated/upgraded.

> Normally queries die if tables involved are removed or
> renamed?

And they still will.

--
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!"