Ms Access calls sql server DTS

[Guest]

How can I design a form in ms access which could call a DTS package in sql
server ? Also it should perform a certain procedure in msaccess.

Thanks
Madhuri

 

[Joerg Ackermann]

How can I design a form in ms access which could call a DTS package
in sql server ?

Try:

Sub DTSExecutePackage()
Dim dtsPackage As New DTS.Package
dtsPackage.LoadFromStorageFile "F:\ACCESS\DTSSAMPLE.dts", ""
dtsPackage.Execute
End Sub

A reference to "Microsoft DTSPackage Object Library" is nessesary.


Acki

 

[Guest]

The problem with MsAccess form coding is that it dosent show me any
components or references to add from. Any idea on where to add these
references ?

Madhuri

 

[Joerg Ackermann]

The problem with MsAccess form coding is that it dosent show me any
components or references to add from. Any idea on where to add these
references ?

In VBA-Ediitor - Tools - References


Acki