Hi, I'm trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I've designed a DTS local package as follows: '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ I Function ConvertIssue3() Dim objDB Set objDB = CreateObject("Access.Application") objDB.OpenCurrentDatabase("H:depConvertConvert.mdb") objDB.Run "ConvertIssueSlips" objDB.CloseCurrentDatabase objDB.Quit ConvertIssue3 = DTSTaskExecResult_Success End Function Originally I thought it might be a security issue, but when I change ownership of the job to a user without admin privileges, the job simply fails, where if I make sure the owner is an admin, the job hangs. In the package I changed clicked both boxes in the work flow properties tab: Use ActiveX script and Execute on main package thread. I've tried just about every combination of these options, and I still have the hang problem. Does anyone have any idea what might be going wrong. I've searched the internet for a while and have yet to come up with a solution. If not, does anyone know of a different way to run the Ms Access file? Any advice will help. Thanks.

Software/Hardware used: