William Hindman
wdhindman at dejpolsystems.com
Wed Feb 10 01:23:28 CST 2010
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 >>> >> >> >> __________ 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 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >