Thanks phillcart.

Found some good scripts which I modified to EXECUTE a DTS package from within a DTS package, after testing for db file existence. 

I decided that it would be easier to abandon implementing a trigger and to run everything from within a DTS package.

Thanks to everyone who responded to my post, your help was appreciated.

The DTS package uses a Data Pump task that opens an access MDB table, extracts the data into an MS SQL table and then terminates.

This seems to be simillar to a...

Thank you for a speedy reply to my post.

Just to clarify one thing; I have created a DTS package that is scheduled to run periodically. The package performs the task...