backup vb script

[dale5804]

hi, am i being thick....
seen on another post from the past what looks like a simple but great scrip to put on 'as described' on your main form n the event 'on close'

Dim SourceFile, DestinationFile
       SourceFile = "C:\TestDir\Test.mdb"          ' Define source file name.
      DestinationFile = "C:\TestDir\Test2.mdb"    ' Define target file name
      FileCopy SourceFile, DestinationFile    ' Copy source to target.

but when i try it i get a runtime 70 error, access not permited??
cheers

[ADezii]

hi, am i being thick....
seen on another post from the past what looks like a simple but great scrip to put on 'as described' on your main form n the event 'on close'

Dim SourceFile, DestinationFile
       SourceFile = "C:\TestDir\Test.mdb"          ' Define source file name.
      DestinationFile = "C:\TestDir\Test2.mdb"    ' Define target file name
      FileCopy SourceFile, DestinationFile    ' Copy source to target.

but when i try it i get a runtime 70 error, access not permited??
cheers

You cannot copy the Database if you are currently working in it.

[dale5804]

You cannot copy the Database if you are currently working in it.

thought so, but reading the other thread, it sounding like they could do it.
cheers anyway

[NeoPa]

You could think of triggering a Cmd Script (.Cmd file) in your OnClose event that schedules a copy for ten seconds hence.
As scheduled tasks typically have limited access to the network though, it might be more prudent simply to start the copy job directly but with a command that would give a short delay running before the copy itself.