jwcolby
jwcolby at colbyconsulting.com
Fri Sep 3 00:00:47 CDT 2010
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 >> >