Heenan, Lambert
Lambert.Heenan at chartisinsurance.com
Tue Aug 10 13:23:42 CDT 2010
Thanks Charlotte. Of course we all know how good the help system is now post A-97, so maybe it's no surprise you couldn't find it. Yet I still have an inkling that I read somewhere that they had got around to documenting it. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, August 10, 2010 1:00 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] "Test to Production" Procedures for Access2007 application in a small environment Nope, not in 2007 help anywhere I can find. Charlotte Foust On Tue, Aug 10, 2010 at 9:28 AM, Heenan, Lambert <Lambert.Heenan at chartisinsurance.com> wrote: > I'm pretty sure that M$ got around to documenting /decompile in version 2007 and higher, though I have not yet inflicted myself with that version. Anyone care to search Help and confirm? > > Lambert > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: Tuesday, August 10, 2010 12:11 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] "Test to Production" Procedures for Access2007 > application in a small environment > > Brad / Jim > > It is not technically correct to say that Decompile is untested. It is undocumented. > > Decompile was created long ago by Microsoft (of course) to allow beta testers a means of flushing the pcode buffers and forcing a new compile of code. It remains "undocumented" because Microsoft does not want to be liable for any damage caused by its use, and perhaps more realistic, because MS does not want to publicize the fact that VBA would have bugs forcing a decompile. > > Of course you should back up your database before use. OTOH you should backup your database anyway. > > I have used decompile for many years and never had a failure specifically caused by the act of decompiling. YMMV. I consider decompile 100% solid. > > Your English language VBA code is "compiled" (interpreted really) and turned into PCode, and placed into specific places in the MDB. The PCode is what actually runs. In fact the PCODE is what is shipped in an MDE when you "strip out" the vba text files. > > Decompile really is just a flush of the pcode streams. Flushing those buffers is a really low risk operation in the overall scheme of things. > > > John W. Colby > www.ColbyConsulting.com > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com