[AccessD] decompile doesn't continue

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




More information about the AccessD mailing list