[AccessD] Dirty Cancel Clear all controls

[Dan Waters]

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