Charlotte Foust
charlotte.foust at gmail.com
Fri Sep 3 01:26:53 CDT 2010
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 >