Have writting an Access ADP that calls a SQL DTS
package, works fine on my computer, but when i
give it to a user. It does not find the DTS Object
Library in references.

So how do I installl the DTS object library on the
users computer?

You may have to install the sql server client on the user's desktop.
That will install all the dts supporting files.

Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You don't need the whole client.

Have a look here

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Partha Mandayam" <mcp111 (AT) hotmail (DOT) com> wrote

Allan,

How can you distribute these files with an Access ADP? With VB there is
a Package and deployment wizard but I don't know of any such thing in
Access. That's why I suggested to install the SQL Server client

Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You could build your own MSI that did this or simply write a batch file that
registered the DTS dlls for you.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Partha Mandayam" <mcp111 (AT) hotmail (DOT) com> wrote

Thanks

On Wed, 12 May 2004 21:36:28 +0100, "Allan
Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote: