[AccessD] Dirty Cancel Clear all controls

[Dan Waters]

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

On 14 Feb 2018 at 14:56, Rocky Smolin wrote:

> I've used the Decorrupter posted here a few months ago several times
> and it's saved my bacon every time.  It exports all the objects and
> reimports them and everything comes out looking just dandy.
>
> R
>
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of Arthur Fuller Sent: Wednesday, February 14, 2018 1:32 PM To: Access
> Developers discussion and problem solving Subject: Re: [AccessD] Dirty
> Cancel Clear all controls
>
> This bug has been lurking in Access VBA for years, and other than the
> fact that I know what to do when it bites me, I have no information or
> insight regarding its cause or this bug, or the apparent
> inability/unwillingness of the Access team to repair it.
>
> What I have discovered, through trial and error rather than insight,
> is that a second solution exists: export the code to a text file and
> then re-import it, which is functionally the same, of course. I've
> done this and noted that the "junk code" is magically eliminated
> during the export.
>
> Sidebar question:
>
> I've never inspected the exported text from a form to see if the
> re-imported text can totally recreate the form of interest. Do you
> know? My thought is that somewhere all this data is stored as text,
> but perhaps limits its export. I don't really know, but if it is, then
> reverse-engineering some samples ought to provide enough information
> to design a text-template system that auto-generates a bunch of forms
> (perhaps containing subforms, in which case recurse).
>
> I've written a lot of code similar to the spec described above, in
> languages other than Access, but never tried it in Access. Do you have
> any experience in this sort of experiment?
>
> Arthur

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