i only get a problem like that when my linked tables dont work. (thats because i moved the source databse to another folder making me have to relink the tables) judging from what it saying is vba simply cant open the file that your trying to open, the path for the file may have changed...