Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Wed Feb 10 00:50:00 CST 2010
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 >>> > > > __________ Information from ESET NOD32 Antivirus, version of virus > signature > database 4852 (20100209) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.esetnod32.ru > __________ Information from ESET NOD32 Antivirus, version of virus signature database 4852 (20100209) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru