Can someone take a look at this

[Oldsoftboss]

I have created a back up utility that works fine when I test it at home. I copy from my networked desktop to a thumb drive and any combination in-between and it never faults. I supplied it to a company and every time they use it, it faults and brings up error 5 - "Disk is Full"

I talked them through it and tried to copy it to several different locations (C:\ wont even work). I am thinking they have some sort of security setting on their PC that wont let it do its stuff.

Any suggestions ?

PS - The company is over 300 miles away so visiting is not really an option without a fix in mind.

Dave

 

[access_learner]

worked fine here.

saved it in a few diff directories.
no problems.

can they back up to floppy ??? cos maybe there computers are all nodes running on a server where they cant store it or seomthing......perhaps you shoulod talk to their admin and see why they think it wont work.

cos it does work, fine.
has to be something at their end.

 

[WayneRyan]

Dave,

You need to Shell & Wait.

They're using the TRIAL version of WinZIP (or they have large databases).

I'll post a Shell & Wait if you need it.

Wayne

 

[ghudson]

The zipping routine I use to backup a file will not work with the demo version of WinZip. The user has to have a licensed version of WinZip.

 

[Oldsoftboss]

The Shell & Wait sounds like what I need (If you can)

I never considered the "TRIAL version of WinZIP" factor.

ghudson.... Thanks for the code

Dave

 

[Oldsoftboss]

PS.. Thanks for the feedback.

 

[WayneRyan]

Dave,

Sorry, been busy ...

'
' Call BCP to export a file
'
While Not rs.EOF And Not rs.BOF
   ' Shell BCP Command and wait ...
   strCmd = Chr(34) & strApp & Chr(34) & _
            Me.cboTrans & ".." & rs!Name & " out c:\ewds_update\" & rs!Name & ".txt -Sbrian\some_sql_server -n -T" & Chr(34)
   start.cb = Len(start)
   ReturnValue = CreateProcessA(0&, strCmd, 0&, 0&, 1&, NORMAL_PRIORITY_CLASS, 0&, 0&, start, proc)
   Do
      ReturnValue = WaitForSingleObject(proc.hProcess, 0)
      DoEvents
      Loop Until ReturnValue <> 258
   ReturnValue = CloseHandle(proc.hProcess)
   ' Get Next Table
   rs.MoveNext
   Wend
'
' Put in a Public Module
'
Public Type STARTUPINFO
   cb As Long
   lpReserved As String
   lpDesktop As String
   lpTitle As String
   dwX As Long
   dwY As Long
   dwXSize As Long
   dwYSize As Long
   dwXCountChars As Long
   dwYCountChars As Long
   dwFillAttribute As Long
   dwFlags As Long
   wShowWindow As Integer
   cbReserved2 As Integer
   lpReserved2 As Long
   hStdInput As Long
   hStdOutput As Long
   hStdError As Long
End Type

Public Type PROCESS_INFORMATION
   hProcess As Long
   hThread As Long
   dwProcessID As Long
   dwThreadID As Long
End Type

Public Declare Function WaitForSingleObject Lib "kernel32" (ByVal hHandle As Long, ByVal dwMilliseconds As Long) As Long

Public Declare Function CreateProcessA Lib "kernel32" (ByVal _
   lpApplicationName As Long, ByVal lpCommandLine As String, ByVal _
   lpProcessAttributes As Long, ByVal lpThreadAttributes As Long, _
   ByVal bInheritHandles As Long, ByVal dwCreationFlags As Long, _
   ByVal lpEnvironment As Long, ByVal lpCurrentDirectory As Long, _
   lpStartupInfo As STARTUPINFO, lpProcessInformation As _
   PROCESS_INFORMATION) As Long

Public Declare Function CloseHandle Lib "kernel32" (ByVal hObject As Long) As Long

Wayne