[AccessD] SaveAsText/LoadFromText Problems:

> >Ken:
> >SaveAsText/LoadFromText does NOT:
> > a) Fix all kinds of bloat
> > b) Reset the form lifetime control count limit
>
> Oh, and I just remembered:
>  c) LoadFromText won't load queries with subqueries using the [subquery
> sql]. syntax.
>
> You will have to parse the file for the [ ]. and replace it with () before
> importing.
>
> Again, tested only on A2K.
>
> -Ken
>

And:

 d) Won't load forms/reports with ActiveX controls that you don't have a
design-time license for. More correctly, if you don't have the design-time
license loaded on the machine that you are running EatBloat on, the the load
will fail.

You can fix this by installing the license for the ActiveX control on the
computer you are using EatBloat on.

If you can't do that, you can do the following:

1. Create a stub form from scratch, and copy the ActiveX control on the form
to the stub.
2. Copy the source database, and delete all objects but the stub, and use
that file as the destination.
3. Use SaveAsText to save the form. Parse out the ActiveX definition in the
file.
4. Load the fine into destination.
5. Merge the imported form with the stub.

-Ken