Does anyone have any experience with running an Access subroutine from a DTS package (vbscript)? I've tried using the Call function & get the following error. (also tried changing the sub to a function, but still get the error)
Error Source: DAO Properties
Error Description: Error Code 0
Error Source = Microsoft VBScript runtime error
Error Description: Type Mismatch: 'Att4Sum2'
Error on Line 8
Property not found.
Here's my vbscript code in the DTS package:
Set objDB = CreateObject("Access.Application")
ExportAttachmentData = DTSTaskExecResult_Success