[AccessD] decompile doesn't continue

Heenan, Lambert Lambert.Heenan at chartisinsurance.com
Fri Sep 3 08:23:08 CDT 2010


The second file name with the compact switch is optional. If provided then the compacted database is created with the new name. Without the second file Access compacts to "db1.mdb" and then deletes the old file and renames the new one automatically at the end of the process.


Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Friday, September 03, 2010 7:48 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] decompile doesn't continue

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