[AccessD] DeCorrupter Info

[Fred Hooper]

Hi Dan,

Last night I imported the file that I want to DeCorrupt into a new, 
empty database. (Jim, I believe doing this met the effect of your 
caution.) (Reference: 
https://bytes.com/topic/access/answers/810467-how-rebuild-objects-text-files; 
see the comment from Chris Martin that includes the phrase: "This 
confirms that the problem likely relates to non-native".)

This morning I ran the DeCorrupter on it and it ran perfectly -- 
including rebuilding the five forms and reports that it wouldn't process 
before!

Therefore, I suggest performing these steps before running DeCorrupter:

 1. Create a new, empty database.
 2. Import all of the old databases' objects into it (making sure to
    include menus), then setting the necessary references, options and
    startup values so that it runs properly.
 3. Run the DeCorrupter.


An observation:

I downloaded a copy of the DeCorrupter from your web site yesterday. 
When I compared it with the copy I downloaded from your web site in 
July, 2017 I found differences; the current one appears to be an earlier 
version than the one I downloaded last year. I've placed a copy of it on 
my dropbox (decorrupter - Orig.bdm) so that you can compare it. The 
difference I noticed was in the DestinationFileAlreadyExists function, 
where the new ("Orig") version is aware of .aacsb files while the 
version I downloaded from your web site a few days ago isn't; I didn't 
look for other differences.

I've placed a new version of my changes in dropbox as decorrupter - 
FAH.bdm, which is based on the Orig file. I removed the code and table I 
wrote to handle objects that couldn't be converted, as that is no longer 
an issue for me. (It was written to be specific to my PC anyway, so it 
wouldn't have affected others.)


Program similar to DeCorrupter: 
https://sourceforge.net/projects/access-srcutil/ -- This was written in 
Access 2007 and has been tested on 2000, 2002, 2003 mdb's and 2007 accdb's.

Supersets with portions similar to DeCorrupter: These are open source 
version control systems for Access, I encountered one through a search 
for LoadFromText as they save the Access code in text form.

  * https://github.com/bkidwell/msaccess-vcs-integration -- the original
    attempt, now defunct
  * https://github.com/ArminBra/msaccess-vcs-integration -- forked from
    above
      o 5 contributors, 3 releases, 2 branches
  * https://github.com/timabell/msaccess-vcs-integration -- forked from
    above
      o 23 contributors, 6 releases, 4 branches

I haven't looked at any of these yet, but I'll do so over the next few days.

Best,
Fred

> Jim Dettman <mailto:jimdettman at verizon.net>
> Saturday, February 17, 2018 6:56 AM
> Watch the default DB format that is set in options.
>
> I would imagine with this, the new DB needs to be in the exact same 
> format as the old DB that the objects were exported from.
>
> Jim.
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Fred Hooper
> Sent: Friday, February 16, 2018 5:44 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] DeCorrupter Info
>
> I’ve been thinking of doing so and will.
>
> While I’m waiting for it to arrive I’ve found some interesting things 
> in a search — just on my phone but one thing that stuck through the 
> tiny screen was that the issue can be caused by converted databases 
> and isn’t caused by imported. I’ll try importing everything into a 
> clean db and see if that helps.
>
> Thanks, Fred
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> Fred Hooper <mailto:fahooper at gmail.com>
> Friday, February 16, 2018 5:44 PM
> I’ve been thinking of doing so and will.
>
> While I’m waiting for it to arrive I’ve found some interesting things 
> in a search — just on my phone but one thing that stuck through the 
> tiny screen was that the issue can be caused by converted databases 
> and isn’t caused by imported. I’ll try importing everything into a 
> clean db and see if that helps.
>
> Thanks, Fred
>
> Dan Waters <mailto:df.waters at outlook.com>
> Friday, February 16, 2018 5:25 PM
> Hi Fred,
>
> I wrote the DeCorrupter using Access 2010 on W10 and all still works well.
>
> Do you have an option to use Access 2003?
>
> Dan
>