[AccessD] Compile from the command line

jwcolby jwcolby at colbyconsulting.com
Fri Sep 3 06:50:25 CDT 2010


Cool.  Where do we learn such things?

John W. Colby
www.ColbyConsulting.com


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.
> 
> 



More information about the AccessD mailing list