[AccessD] decompile doesn't continue

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
>