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