Need to see the error message.
Need to know the version of Excel and Access (I assume they are the same, ie, say Office 2016, or whatever).
Could be many reasons, as mentioned above, plus, possibly access (note not Access) rights on the folders / drives involved, not to mention the various setting available with MS Office (attempt) to prevent execution of malicious macros.