[AccessD] decompile doesn't continue

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
>




More information about the AccessD mailing list