[AccessD] Add-In Express 2009 for MS Office and .NET

Thank you, Max.

<<<
5. Credits to AccessD please.
>>>
Sure.

I do not plan to handle tables in my (first) version.
AFAIU/AFAIHS bloating is mainly caused by other object types, and tables
tend to reuse freed space of an MDB file...

But if handle tables in EatBloat then one have also to find a way to handle
relationships - the latter can be done of course with some more coding but
then the following question arises - why not use KISS approach?:

- make backup;
- drop current;
- create new;
- import all objects from backup (.TransferDatabase...);
- recreate relationships;
- get import/export specs;
- get changed database and user defined properties;

?

I'm probably missing something? 

Please advise.

(Yes, I do realize that tables saved as .csv, or .xml together with other
objects saved as text can be kept as a backup (very compact if additionally
zipped) - but that should be called backup/restore utility then?)

Thank you.

--
Shamil

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Thursday, February 11, 2010 12:21 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET

No William, I have used it longer than you <g>
 
Hi William, Dan, Shamil etc,

Sorry for not responding. Had a head cold which knocked me a bit.
Recovering a bit  now.

Basically, a single form (don't have to strip  it out William when creating
mde, just let it sit there - even tell the customer to run it weekly as a
backup mechanism. If it is an add-in, it will be there  anyway??).

1. Options are to export/import objects to/from text output/input.

2. Objects are tables (as csv, xls or xms),
queries/forms/reports/macros/modules (as text)

3. All or individually.

4. A2k3 based.

5. Credits to AccessD please.

6. Name comes from EAT (Export as Text) and Bloat (reduce bloat when
reimporting the objects).  Hence, EATBloat.

7. Works best when first installed in a working mdb and then export the
objects while everything is ok.  Then when trouble comes,  create  a new
mdb, load EatBloat form and import all the objects again.

8. If I have missed any questions, please come back.

Thanks

Max



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
Sent: 10 February 2010 20:36
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET

Dan

...I've used Max's EatBloat for the longest time ...that said, the process 
of including it within my mdb file meant I always had to strip it out just 
before producing an mde for my clients ...rewriting it as an add-in would 
provide all the benefits without having to import it into each of my mdbs 
and remembering to delete it before production ...just less work for me 
...and much easier to use over a number of mdbs.

...my opinion of course, worth what it cost you :)

William
--------------------------------------------------
From: "Dan Waters" <dwaters at usinternet.com>
Sent: Wednesday, February 10, 2010 2:05 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET

> Max had all the functionality in a single form, which I liked.  That way a
> developer can just include it in any access file!
>
> This won't be commercial - when it's done I'll turn it over to Access D 
> for
> 'ownership'.
>
> Dan
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
> Salakhetdinov
> Sent: Wednesday, February 10, 2010 12:07 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET
>
> Hi Dan --
>
> I didn't know.
> Please do it.
> What I plan to do is a "lightweight" version of "EatBloat" within Access
> Developer Assistant add-in - just a "Proof Of Concept". And it will need
> .NET Framework 3.0/3.5 installed on target system. Not all MS Access
> developers will want to have it on their systems.
>
> Or do you plan to make a commercial version of "Eat Bloat"?
> Then I will not make its "lightweight" version within Access Developer
> Assistant.
>
> Thank you.
>
> --
> Shamil
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> Sent: Wednesday, February 10, 2010 8:26 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET
>
> Hi Shamil,
>
> Several months ago I started rewriting the Eat Bloat form from Max.  I got
> about 70% done and had to stop due to workload.  But I can now get this 
> done
> in the next few days.  Let me suggest that you hold off on Eat Bloat for
> now.  If what I do is something you still want to incorporate, then by all
> means please do.
>
> Thanks!
> Dan
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
> Salakhetdinov
> Sent: Wednesday, February 10, 2010 11:06 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET
>
> Thank you, William,
>
> I will try to make a sample "Access Developer Assistant Add-in" using
> "Add-In Express for Office and .NET" with:
>
> - Decompile and
> - "Eat bloat"
>
> functionality available next week...
>
> --
> Shamil
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
> Sent: Wednesday, February 10, 2010 6:40 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET
>
> ...yeehah!!!!!! :)))))))
>
> ...need a beta tester? ...I'm available :)
>
> William
>
> --------------------------------------------------
> From: "Shamil Salakhetdinov" <shamil at smsconsulting.spb.ru>
> Sent: Wednesday, February 10, 2010 7:16 AM
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET
>
>> William,
>>
>> Yes, no one can be sure about anything these days - that's a living
>> "context" all around the world AFAICS...
>>
>> OK, I will make EatBloat.NET prototype within Access Developer Assistant
>> Add-in with all credits to Max - OK Max?
>>
>> Thank you.
>>
>> --
>> Shamil
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William 
>> Hindman
>> Sent: Wednesday, February 10, 2010 10:23 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET
>>
>> Shamil
>>
>> ...no one can be sure about anything here these days ...but that gets 
>> into
>> politics and economics and anything
>> more I'd say would be sure to piss someone off on the list, eh :)
>>
>> ...I think you've probably identified the core of EatBloat ...after the
>> import, I'd think you'd want to add a compact.
>>
>> William
>>
>> --------------------------------------------------
>> From: "Shamil Salakhetdinov" <shamil at smsconsulting.spb.ru>
>> Sent: Wednesday, February 10, 2010 1:50 AM
>> To: "'Access Developers discussion and problem solving'"
>> <accessd at databaseadvisors.com>
>> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET
>>
>>> William --
>>>
>>> But you suppose that "lazy season" will last just a few months there?
>>> How one can be sure about that?
>>>
>>> OK, AFAIS "Eat Bloat" uses undocumented features .SaveTex/.LoadText
>>> therefore it shouldn't touch/bother about tables and relationships but
>>> just:
>>>
>>> - make backup copy of current db;
>>> - save queries, forms, reports, macros, modules as text files;
>>> - delete queries, forms, reports, macros, modules;
>>> - compact db;
>>> - load queries, forms, reports, macros, modules from saved text files.
>>>
>>> (if db to fix has AutoExec macro or start-up form then they should be
>>> disabled manually before "Eat Bloat" run)
>>>
>>> Correct Max?
>>>
>>> Thank you.
>>>
>>> --
>>> Shamil
>>>
>>>
>>> -----Original Message-----
>>> From: accessd-bounces at databaseadvisors.com
>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
>>> Hindman
>>> Sent: Wednesday, February 10, 2010 1:16 AM
>>> To: Access Developers discussion and problem solving
>>> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET
>>>
>>> Shamil
>>>
>>> ...not idle ...just a significant cutback in the work available ...we've
>>> hit
>>>
>>> over 18% unemployed here in Palm Beach including those who have just
>>> stopped
>>>
>>> looking or ran out of unemployment benefits ...my largest client asked
>>> for
>>
>>> a
>>>
>>> 50% cut in project hours, just stringing things out ...other clients 
>>> have
>>> done the same or stopped work altogether ...so there is plenty of slack
>>> time
>>>
>>> available right now, time for learning new things, cleaning up old ones
>>> :)
>>>
>>> ...Eat Bloat exports everything to text files, then re-imports them, 
>>> used
>>> to
>>>
>>> work like a charm but there is a bug in the latest version that errs out
>>> ...Max would have to give you the inner workings.
>>>
>>> William
>>>
>>> --------------------------------------------------
>>> From: "Shamil Salakhetdinov" <shamil at smsconsulting.spb.ru>
>>> Sent: Tuesday, February 09, 2010 2:33 PM
>>> To: "'Access Developers discussion and problem solving'"
>>> <accessd at databaseadvisors.com>
>>> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET
>>>
>>>> William and Max --
>>>>
>>>> What "Eat Bloat' actually does? (sorry I didn't use it)
>>>>
>>>> - Creates new mdb...
>>>> - and exports all MS Access objects (tables, queries, forms, reports,
>>>> macros, modules) into this new mdb?
>>>>
>>>> What about relationships?
>>>> What about import/export specs?
>>>> What about ADPs?
>>>>
>>>> <<<
>>>> I'm looking for the next step up allowing creating a new mdb from
>>>> multiple
>>>> preset configs...
>>>>>>>
>>>> MS Access Applications Manager did something like that - in fact it was
>>>> able
>>>> to create one solid FE together with BE or one shell FE with as many as
>>>> one
>>>> wanted to have library FEs (with forms and reports in that libraries)
>>>> and
>>>> one/several BEs with linked tables etc. - all built "automagically"
>>>> including SageKey InstallShield script with ready to use setup kit in
>>>> the
>>>> end - something like that AFAIKR...
>>>>
>>>> <<<
>>>> ...I may
>>>> invest in A2010 if the early reviews hold up but A2K7 is no-no for me
>>>> ...still A2k3 bound :)
>>>>>>>
>>>> As I noted Add-In Express does allow to develop version independent
>>>> Add-ins
>>>> including their setup - there will be no need to keep several code
>>>> versions/branches/setups - there should just be custom description of
>>>> what
>>>> custom add-in features are used for what target MS Access version...
>>>>
>>>> <<<
>>>> ...I'm more than willing to give it a try but as you know I'm no code
>>>> guru
>>>>>>>
>>>> OK
>>>>
>>>> <<<
>>>> ...but the economy here ensures that I'll have some time available for
>>>> the
>>>> next few months anyway and I have Visual Studio Pro 8 to work with
>>>>>>>
>>>> Do you mean current global recession which may force you to stay idle
>>>> for
>>>> the next few months?
>>>>
>>>> Thank you.
>>>>
>>>> --
>>>> Shamil
>>>>
>>>> -----Original Message-----
>>>> From: accessd-bounces at databaseadvisors.com
>>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
>>>> Hindman
>>>> Sent: Tuesday, February 09, 2010 10:00 PM
>>>> To: Access Developers discussion and problem solving
>>>> Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET
>>>>
>>>> Shamil
>>>>
>>>> ...I think Max has already passed Eat Bloat off to AccessD ...iirc JC
>>>> was
>>>> going to put it into a class structure as time allowed ...bloat is
>>>> certainly
>>>>
>>>> a continuing problem at least through A2K3 ...Eat Bloat used to do
>>>> wonders
>>>> for me in fixing transient problems as well as bloat but the latest
>>>> version
>>>> just errors out for me ...been waiting for JC to get a revised version
>>>> out
>>>> ...your App Mgr certainly sounds like a most worthwhile replacement.
>>>>
>>>> ...as to properties I'm referring to those we set when we start a new
>>>> mdb
>>>> design ...jc has an addin C2DbProperties that does a number of them but
>>>> I'm
>>>> looking for the next step up allowing creating a new mdb from multiple
>>>> preset configs ...I use different settings for an mdb in design than I
>>>> do
>>>> one ready to be compiled into an mde.
>>>>
>>>> ...I hope you can work something out with the vendor but from his site
>>>> it
>>>> doesn't look like he'd be partial to the idea ...that doesn't mean you
>>>> couldn't share the workload of course, just not sure the codeplex
>>>> license
>>>> would work in this case.
>>>>
>>>> ...I'm more than willing to give it a try but as you know I'm no code
>>>> guru
>>>> ...but the economy here ensures that I'll have some time available for
>>>> the
>>>> next few months anyway and I have Visual Studio Pro 8 to work with ...I
>>>> may
>>>> invest in A2010 if the early reviews hold up but A2K7 is no-no for me
>>>> ...still A2k3 bound :)
>>>>
>>>> William
>>>>
>>>> <<< snip >>>
>>>>
>>
>>
>> -- 
>> 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
>
> __________ Information from ESET NOD32 Antivirus, version of virus 
> signature
> database 4854 (20100210) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.esetnod32.ru
>
>
>
> -- 
> 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
>
> __________ Information from ESET NOD32 Antivirus, version of virus 
> signature
> database 4854 (20100210) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.esetnod32.ru
>
>
>
> -- 
> 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
> 

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

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4855 (20100210) __________

The message was checked by ESET NOD32 Antivirus.

http://www.esetnod32.ru