jwcolby
jwcolby at colbyconsulting.com
Fri Sep 3 06:48:17 CDT 2010
That compact does work, it does the typical "compact to a new filename and then switch back to the original when done". John W. Colby www.ColbyConsulting.com Charlotte Foust wrote: > Yes, but you're telling it to compact without giving it a destination > filename. I don't think that would run, since behind the scenes, it > ALWAYS compacts to a new filename. > > Charlotte Foust > > On Thu, Sep 2, 2010 at 10:00 PM, jwcolby <jwcolby at colbyconsulting.com> wrote: >> I thought the new file name thing was for the compact switch. >> >> John W. Colby >> www.ColbyConsulting.com >> >> >> Charlotte Foust wrote: >>> Don't you have to specify a new filename to compact to, John? I know >>> internally, Access compacts to a new file name and then deletes the >>> old file and renames the compacted version to the old filename. That >>> could be why the process stops after the decompile. A batch file >>> wouldn't return the error messages you would get from code or the db >>> window. >>> >>> Charlotte Foust >>> >>> On Thu, Sep 2, 2010 at 9:18 PM, jwcolby <jwcolby at colbyconsulting.com> wrote: >>>> 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 >> >