How to copy a file from within an access app to a CD drive

[ncsthbell]

I am using 'fs.copyfolder' to copy folder data to a network location, this is working fine. Now I need to write this folder and contents out to a cd drive instead of to the network. I have tried using fs.copyfile "c:\fileABC" to "d::\fileABC" (D is my drive for the cd writer). Has anybody written/copied files like this out of an access application?

[Stewart Ross]

Hi. Is there some reason why you cannot use Copyfolder once again?

I use the filesystem object to copy a database file from a live location to an off-line location on a different server. The bare code for doing so (without the setting of the from and to strings and all the user messages etc concerned) is extracted and listed below:

Dim fso As Object, f2 As Object
    Dim strCopyFrom As String, strCopyTo As String
    Set fso = CreateObject("Scripting.FileSystemObject")
    ..<from and to strings need to be passed as parameters or otherwise set before use>..
    Set f2 = fso.GetFile(strCopyFrom)
    f2.Copy (strCopyTo)
    Set fso = nothing
    Set f2 = nothing

However, writing to a CD drive may be problematic, as the files may well need to be cached until you write them to the drive under manual control. It may well be better to write the folder to a temporary folder area and then transfer them to CD when your drive writing software is available under manual control...

-Stewart

[ncsthbell]

Thanks for your reply. I am currently using the FSO method to copy the file from the C drive to a network drive. This works fine. The problem is that my users want me to copy the file to a cd disk 'automatically' in the code so they do not have to do this manally.
I substitued my 'to' location with the drive letter 'D:" (is the cd drive on my machine). I thought when the code was executed it would prompt me to put in a cd once it hit the copy code for the drive 'D', however, that is not what happens. Code just gets hung and does nothing.

[Stewart Ross]

Hi. I haven't tried writing to a CD drive myself, so all I can do is to suggest that this is not likely to work as you expect. Writing to a rewritable CD or to a write-once CD-ROM does not work the same way as a hard disk or a flash drive, and I really doubt the the FSO routines were built for such drives. Hence why I reckoned that writing to such disks would be a manual process, and I advocated writing to a temporary folder instead (or a different medium).

At the very least, you are going to have to detect the state of the drive itself before you attempt to write to it, then figure out how to write the cached set of files to the drive. This is likely to involve calls to Windows API functions in one form or another, well beyond the use of the file system object itself I reckon.

-Stewart