Jim Dettman
jimdettman at verizon.net
Tue Feb 16 12:27:19 CST 2010
Shamil, <<AFAIKR I have had a discussion here on AccessD or on Access-L(?) quite some time ago - I cannot find it on Internet, which was called "Getting sources from MS Access MDE". >> I remember that. Not sure if I have a copy anywhere here or not. If I find some free time latter, I'll look just for the heck of it. I remember at the time that everyone was shocked that you could pull stuff from a MDE, but after you pointed out that only source code was stripped, that it was still possible to get all the objects and their properties. MDE's were relatively new and everyone had the concept stuck in their heads that it was a DB that was locked up tight. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil Salakhetdinov Sent: Tuesday, February 16, 2010 12:08 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] DBRepair (EatBloat+) Was: Re: AccessD Digest, Vol 84,Issue 23 <<< This would be an attractive project for me to take on if it would solve problems not just for A2K, but for more recent versions as well. >>> Hi Ken -- You are welcome to implement this functionality as an Access.PowerTools plug-in in one of its future releases if you plan this your tool to be shared on MIT license basis... AFAIKR I have had a discussion here on AccessD or on Access-L(?) quite some time ago - I cannot find it on Internet, which was called "Getting sources from MS Access MDE". The issue was that one of the developers lost their source mdb, and they didn't have resources to purchase a tool extracting/recreating forms' and reports' designs out of mde. And that time I had written a small tool mdb, which did run subject .mde in Automation mode, did open all its forms and reports, and did get forms' and reports' design out of that mde recreated form by form, report by report, control by control - that could have been in some parts similar to your code but I must say I can't find its sources now - they are buried somewhere on my old disconnected HDDs - that code was just creating forms and reports in VBA, extracting their properties by iterating properties collections of forms/reports sections and controls, creating target forms'/reports' sections and controls and assigning properties' values using .add property - something like that relatively simple but efficient - and it did the job well... And I was unaware that time that solution was much closer - as undocumented .SaveAsText feature could have got forms', reports', and macros designs out of .mdes: Access.PoweTools can do that now - just a side effect/benefit feature of this tool. Thank you. -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kenneth Ismert Sent: Tuesday, February 16, 2010 12:20 AM To: accessd at databaseadvisors.com Subject: [AccessD] DBRepair (EatBloat+) Was: Re: AccessD Digest, Vol 84, Issue 23 Some background on my code, which I called DBRepair: I developed it to clean up a stubbornly corrupted database for a company I previously worked for, and the principals are uncomfortable with the idea of open-sourcing it. However, if I completely rewrote the code under .NET, that would remove any proprietary restrictions. This would be an attractive project for me to take on if it would solve problems not just for A2K, but for more recent versions as well. -Ken -- 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 4869 (20100215) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru __________ Information from ESET NOD32 Antivirus, version of virus signature database 4871 (20100216) __________ 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