Heenan, Lambert
Lambert.Heenan at chartisinsurance.com
Fri Sep 3 11:49:58 CDT 2010
Correct. But Stuart came up with the right answer RunCommand (AcCommand.acCmdCompileAndSaveAllModules) Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, September 03, 2010 12:24 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] decompile doesn't continue Lambert, > As for compiling, that's simple, from you batch file just call a macro that executes some code. Access will compile the application then run the code. Just have the code end with Application.Quit. Not so. Decompiled code is compiled at the instant each module is loaded the first time. Thus only the module that contains the function that you execute would be compiled because only that module would be loaded. John W. Colby www.ColbyConsulting.com Heenan, Lambert wrote: > To decompile the command line is... > > "<PathToAccess>\MSAccess.exe" /decompile "<pathtoMdb>\yourfile.mdb" > > Unlike compacting which is... > > "<PathToAccess>\MSAccess.exe" "<pathtoMdb>\yourfile.mdb" /compact > > This is what's called using a consistent interface. In MS Land. > > As for compiling, that's simple, from you batch file just call a macro that executes some code. Access will compile the application then run the code. Just have the code end with Application.Quit. > > Lambert > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: Friday, September 03, 2010 12:19 AM > To: Access Developers discussion and problem solving > Subject: [AccessD] decompile doesn't continue > > I am attempting to decompile in a batch file. I need to decompile my framework, compact the framework, decompile the fe, compact the fe. > > I put it all in a batch file and the decompile opens the framework and stops. If I manually close Access then the batch file continues processing. > > Does anyone know how to do this without the batch file stalling on the decompile? > > rem Copy from server to local > xcopy W:\disnew\C2DbFWA2K.mda c:\Dev\Disnew /Y > > rem decompile and compact > "C:\Program Files\Microsoft Office\Office\Msaccess.exe" > c:\Dev\Disnew\C2DbFWA2K.mda /Decompile "C:\Program Files\Microsoft > Office\Office\Msaccess.exe" c:\Dev\Disnew\C2DbFWA2K.mda /compact > > rem copy to final > xcopy c:\Dev\Disnew\C2DbFWA2K.mda c:\DisFE /Y > > rem copy to local > xcopy W:\disnew\Disco_FE.mdb c:\Dev\Disnew /Y > > rem decompile and compact > "C:\Program Files\Microsoft Office\Office\Msaccess.exe" > c:\Dev\Disnew\Disco_FE.mdb /Decompile "C:\Program Files\Microsoft > Office\Office\Msaccess.exe" c:\Dev\Disnew\Disco_FE.mdb /compact > > > -- > John W. Colby > www.ColbyConsulting.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