DTS package - running in Access

[cupofteawithsugar]

Hi,

I am quite stuck on the following problem I have tried a number of things I have found on the forums - none have worked!

I would like to run a DTS package in Access. I have given the user permissions to all the tables used in pacakge but they dont have enough permissons to run it. I dont know if this is because of the bulkload transfer or temporary table.

I have then decided to create a temporary user with enough permissons to run the package. However I cant seem to find out the correct way to change the current user in the Access adp to only run the DTS package.

I therefore would like to change the correct user in the adp project and then run the DTS package.

Thanks in advance.

 

[TomKane]

How are you attempting to rin the DTS package?

 

[TomKane]

I mean run not rin - apologies!