[AccessD] DBRepair (EatBloat+) Was: Re: AccessD Digest, Vol 84, Issue 23

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




More information about the AccessD mailing list