HI:
i need use an ACCESS'97 module written in VBA to execute a
DTS package on a SQL Server 7 Instance:
i am getting all balled up in the object model that the
references regarding DTS packages to ACCESS are exposing;
would someone plse explain the object model ? (sample code
would be very welcome..)
thank you

You might find it easier to create a stored procedure that executes your DTS
package, and then create a pass through query in Access to run your stored
procedure.

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com


"vern.degeus" <(E-Mail Removed)> wrote in message
news:8bb001c37ee6$0ed9d2c0$(E-Mail Removed)...
> HI:
> i need use an ACCESS'97 module written in VBA to execute a
> DTS package on a SQL Server 7 Instance:
> i am getting all balled up in the object model that the
> references regarding DTS packages to ACCESS are exposing;
> would someone plse explain the object model ? (sample code
> would be very welcome..)
> thank you