[AccessD] Compile from the command line

Alternatively, it turns out there is a documented command.

If Command = "Compile" Then
RunCommand (AcCommand.acCmdCompileAndSaveAllModules)
Application.Quit
End If


-- 
Stuart

On 3 Sep 2010 at 7:42, Jim Dettman wrote:

> 
> A call to SysCmd(504, 16483) will compile a VBA project.  That coupled
> with your startup idea should take care of John's problem.
> 
> Warning:  Syscmd(504,x) is un-documented.  Your mileage may vary.
> 
> Jim. 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
> McLachlan Sent: Friday, September 03, 2010 2:55 AM To: Access
> Developers discussion and problem solving Subject: Re: [AccessD]
> Compile from the command line
> 
> Include an Autoexec macro in  your database which calls a startup
> function. In your startup function include the line.
> 
> If Command = "Compile" Then Application.Quit
> 
> Then in your batch file, ue the switch /cmd "Compile"
> 
> The database will compile itself when the Startup function is loaded
> and the function will then close the database.
> 
> 
> -- 
> Stuart
> 
> 
> 
> On 3 Sep 2010 at 0:33, jwcolby wrote:
> > When you decompile a database it leaves the database in a state
> > where the source needs to be compiled.  You can do the /decompile
> > from the command line but there seems to be no /compile command line
> > switch.
> > 
> > When using a library, if you truly want to correctly implement the
> > decompile / compile, the lib needs to be decompiled / compiled and
> > the the FE needs to be decompiled / compiled.  It is easy to do but
> > a batch file would still be nice.  Unfortunately since there is no
> > /compile command line switch I am finding no way to actually do it
> > all in one batch file.
> > 
> > -- 
> > 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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>