[AccessD] DeCorrupter Info

Dan Waters df.waters at outlook.com
Fri Feb 16 11:43:06 CST 2018 

Hi Fred,

I had no idea that you had looked at this so thoroughly and made valuable changes.  This DeCorrupter was written in Access 2010 - although I created the file as an .mdb.

I don't have all the different versions of Access - I'll probably need to find a way to run test with all the versions.  

I sent Carolyn a test version to get more filepath information - We'll see what happens.

And - you mentioned that I could find the changes by looking for FAH in the modules - but where can I find those modules?

Thank you!
Dan

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Fred Hooper
Sent: February 16, 2018 11:30
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Dirty Cancel Clear all controls

Hi Dan,

The decorrupter has an implicit assumption that the MDB being decorrupted is being run (in the decorrupter) by the same version as created it; it obtains the Version from Application.Version -- which refers to the EXE, not the MDB. In thinking about it, I believe that's the only way you could create the decorrupter program; perhaps if the versions are close it works properly, but the 10 years between Carolyn's versions probably brought too many changes.

So decorrupter is identifying Carolyn's code as version 14 and attempting to export/import a version 9 mdb.

Carolyn, I think you have two choices:

  * Convert your program to some other version and use that version to
    run the decorrupter.
      o 2002 (10) and 2003 (11) are most similar, but the original
        decorrupter didn't handle them. My modifications to do so are
        incomplete, although I'm taking another pass at them today.
      o Versions 12-15 are fully supported by the decorrupter.
          + If I were you (and 2010 permits) I'd convert the MDB to 2010
            (14) and then run the decorrupter. If the program runs
            properly afterwards you're set -- and can run it again if
            you need to.
          + If that doesn't work and you can't find an older Access
            version closer to home I'll convert it to 2002, run the
            decorrupter, and send it back to you.
  * Don't use the decorrupter.

Dan, in this second look for me, I noticed that I added new Version logic code only in TransferOptions. I probably should add it in TransferProperties too. This might be the explanation for the 4 failures to export that I discuss in my Other Access Versions module. I dealt with them by just importing them into the decorrupted MDB; the 200+ successes solved my problems. (You can find my changes by searching for FAH in the modules.)

Best,
Fred
> Dan Waters <mailto:df.waters at outlook.com>
> Thursday, February 15, 2018 6:44 PM
> Hi Carolyn,
>
> I'll look at that tomorrow.
>
> Dan
>
> Sent from my Windows 10 phone
>
> From: cjlabs<mailto:cjlabs at att.net>
> Sent: Thursday, February 15, 2018 17:11
> To: 'Access Developers discussion and problem 
> solving'<mailto:accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Dirty Cancel Clear all controls
>
> When I try to run DeCorrupter, I get an error in CreateDestinationFile 
> -- File Not Found on
> Line 6 fso.CopyFile stgBlankTemplatePath, MstgDestinationFullPath, True
>
> This is a Access 2000 based database, running in Access 2010.
>
>
> Can someone help with that error?
>
>
>
> Thanks
> Carolyn Johnson
>
>
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Rocky Smolin
> Sent: Thursday, February 15, 2018 11:03 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Dirty Cancel Clear all controls
>
> Extremely helpful, Dan. It's uncorrupted several dbs of mine that were not
> amenable to any other method.
>
> r
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Dan
> Waters
> Sent: Thursday, February 15, 2018 6:56 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Dirty Cancel Clear all controls
>
> To all,
>
> The DeCorrupter exports individual objects to text files one by one while
> looping through all the objects (except tables).
>
> Then a new Access file is created programmatically, and all the 
> objects are
> imported from those text files into that new Access file. This ensures 
> that
> whatever may have been going wrong in the original file is left behind.
>
> Good to hear that it's been helpful!
>
> Dan
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Jim
> Dettman
> Sent: February 15, 2018 06:46
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Dirty Cancel Clear all controls
>
>
> It's built on top of Appplication.SaveAsText and Application.LoadFromText,
> so it's different than importing/exporting objects directly.
>
> To answer Arthur's question, it's yes. I've been told that the
> un-documented functions were created to support the creation of DB's from
> templates, but I've never dug into them to verify if that's truly the case
> or not.
>
> Jim.
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Gustav Brock
> Sent: Thursday, February 15, 2018 1:54 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Dirty Cancel Clear all controls
>
> Thanks Stuart
>
> Will the result be different from importing all objects into a new file?
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af
> Stuart McLachlan
> Sendt: 15. februar 2018 01:38
> Til: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Emne: Re: [AccessD] Dirty Cancel Clear all controls
>
> For those not familiar with it, I've posted a copy of Decorrupter at
>
> http://www.camcopng.com/decorrupter
>
> --
> Stuart
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

-- 
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