[AccessD] Cannot Create Output File

Stuart McLachlan stuart at lexacorp.com.pg
Sun Feb 5 16:17:51 CST 2012


Tony, in an earlier post you said you were Shelling to "the Windows zip prgram".

What exactly do you mean by that?  

Windows  handles compressed(zip) files via the Explorer shell and you can use the API or a 
FSO to do it yourself programmatically,   But there is no "zip program" bundled with 
Windows.  

-- 
Stuart

On 5 Feb 2012 at 10:37, Tony Septav wrote:

> Hey Doug
> Thanks for your reply.
> I have a Wait/Sleep of 5 seconds embedded in my code. In my testing of the
> zip code, I am using the same group of files and the message "Cannot Create
> Output File" occurs  erratically sometimes it happens, sometimes not (more
> likely not). Again it is just that I really don't know what the message is
> trying indicate/means.
> 
> Tony Septav
> Nanaimo, BC
> Canada
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
> Sent: Sunday, February 05, 2012 9:22 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Cannot Create Output File
> 
> In my experience it means that there is something wrong with the file path
> or name.  Is it possible that the output file exists already and the program
> isn't set to overwrite existing?
> 
> This may be a red herring, but I remember once discovering that Access was
> feeding files to an external program too quickly for it to handle; I ended
> up putting (I think) a two second delay between calls.
> 
> Doug
> 
> On Sun, Feb 5, 2012 at 7:48 AM, Tony Septav <TSeptav at uniserve.com> wrote:
> 
> > Hey Jim
> > It is kind of weird in my testing, as it is compressing the files 
> > sometimes not always it will hit a file (not always the same one 
> > either) and up pops the message. That is why I was wondering exactly 
> > what the message was trying to tell me. If I knew I could trap for it. 
> > For example maybe it occurs if a file is open, but none of the files 
> > being zipped are open.
> >
> > Tony Septav
> > Nanaimo,BC
> > Canada
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
> > Sent: Sunday, February 05, 2012 7:36 AM
> > To: Access Developers discussion and problem solving
> > Cc: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Cannot Create Output File
> >
> > At a guess it's either the output path is invalid or the login doesn't 
> > have privs for the directory.
> >
> > Jim
> >
> > Sent from my iPhone
> >
> > On Feb 5, 2012, at 9:31 AM, "Tony Septav" <TSeptav at uniserve.com> wrote:
> >
> > > Hey All
> > > I have a form in an 2003 application that allows the user to 
> > > zip/unzip files relating to a project. I am Shelling out to the 
> > > Windows zip
> > program.
> > > Everything basically works fine, but the odd time in the 
> > > archiving/compressing of the files a message box from the zip 
> > > program pops up  "Cannot Create Output File".
> > >
> > > 1. Can someone tell me what this means ( I have tried Goggling for 
> > > an explanation)?
> > > 2. Because the message is outside the application sometimes when I 
> > > click the button in the message box it locks up my application. I 
> > > have tried to close it in Access code but of course to no avail as 
> > > Access is not controlling the program.  Any suggestions?
> > >
> > > Thanks
> > > Tony Septav
> > > Nanaimo, BC
> > > Canada
> > > --
> > > 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
> > -----
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2012.0.1913 / Virus Database: 2112/4789 - Release Date: 
> > 02/04/12
> >
> > --
> > 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
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.1913 / Virus Database: 2112/4790 - Release Date: 02/05/12
> 
> -- 
> 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