Running a DTS package from Access

[sdempsey]

Hi,

I had a DTS package which I saved as VBscript in the save as option box. I then went to my Access adp project and put the VB code against a button. I then included all references to the DTS package.

If I click the button when I am a dbo - the DTS package runs however ever under different permission it does not. I have made sure that the user has permissions to access all the neccessary tables.

Does the user have to be a dbo - in the connection to allow them to run a DTS package from Access?

Thanks

 

[sdempsey]

opps - I forgot to give them permissions to one table.

Sorry about that

 

[DrSql]

Try to give that user PUBLIC access to MSDB and see how it work.

Dr.Sql
Good Luck.