[AccessD] Compile from the command line

Jim Dettman jimdettman at verizon.net
Fri Sep 3 06:42:18 CDT 2010


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




More information about the AccessD mailing list