[AccessD] Development Cycle BE Question

I just tested.

Make sure I have SQL stored. Drop into empty query. Query
rebuilt.

One issue handled. Just downloaded BEU. I will look at that
after work tonight.


Joe Hecht
jmhecht at earthlink.net
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bryan Carbonnell
Sent: Tuesday, January 17, 2006 7:49 AM
To: Access Developers discussion and problem solving
Subject: Re: [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!"
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com