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

Shamil Salakhetdinov shamil at smsconsulting.spb.ru
Thu Feb 11 11:15:43 CST 2010


Lets' make two versions - just to see the difference in development tools -
I'm going to publish all the source code...

Thank you.

--
Shamil

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

Max

...well maybe a little longer ...but not much :)

...I never put add-ins in client deliverables ...begging for problems I 
don't need
...would never consider allowing a client user to run EatBloat ...too many 
possibilities for user error
...anything EatBloat might do in a user environment I do by refreshing the 
fe from the network
...imnsho, EatBloat is a developer tool that doesn't belong in a user's 
hands

...still and all, its one of the most useful tools in my arsenal ...and I'm 
picky :)

...I'd love to Shamil and Dan work together, making it a base plug-in for 
the addin Shamil is developing.
...but whoever produces the next version, I'll be using it.

William

--------------------------------------------------
From: "Max Wanadoo" <max.wanadoo at gmail.com>
Sent: Wednesday, February 10, 2010 4:21 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
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 >>>
>>>>>
>>>





More information about the AccessD mailing list