[AccessD] Compile from the command line

Gustav Brock Gustav at cactus.dk
Fri Sep 3 07:15:55 CDT 2010


Hi John

Like you and me - followed the thread "How to Compile from code" in January/February 2000.

Note that this command cannot compile the module within it is running - this module has to be compiled earlier.

/gustav


>>> jwcolby at colbyconsulting.com 03-09-2010 13:50 >>>
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