Hi guys,
I need to upload a file and link it to the appropriate service. However, I do not want to use the attachment table.
Filenames will be defined as: serviceID + fileName
Destination: \\servername\SalesLogix\Service_Docs\
I am planning to store only the filename in the db. However, I am currently stuck with how to upload the attachment to the destination. Is there any built in function in slx that I can take advantage of? Otherwise, I was planning on using ( BTW, I got it from another post on this site  ):
Dim filesys
Set filesys = CreateObject("Scripting.FileSystemObject")
If filesys.FileExists(fileToBeUploaded) Then
filesys.CopyFile fileToBeUploaded, "\\servername\SalesLogix\Service_Docs\"
End If
Also, if I use the code above will there be any sync problem?
Thanks in advance. |