I have an Active X control in a DTS package that will open a Microsoft Access Database. It works when I run it, but not as an automated job.
When I personally run this DTS package it works, because I have Microsoft Access installed on my computer. When it is scheduled, it errors out with this message- ActiveX component can't create object: 'Access.Application'.
So I think I should install MS Access; but where (on the box where the SQL server is at)? Do I need to set security and permission on my server to allow the service account to launch/execute Access? This is for a large corporate environment.