[AccessD] decompile doesn't continue

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
>>
> 



More information about the AccessD mailing list