How are you connecting to the Access file? Are you using VBA or using the wizard in Excel? Give us some more information on your connection and what is different for the one that is not returning expected results.