what happens if you run each step manually? I have seen something like this if one step is broken and that step might involve, for example, an Access link to a SQL table that has been changed (but Access has not been refreshed since the change)