How do you change a macro path using Access 2013?

8pointz 1 Reputation point
2021-11-02T16:24:43.61+00:00

I was sent an Access 2013 database in email which I saved to my desktop. The database is supposed to pull Excel files in a folder and provide an output Excel file into a different folder. There is a macro which is supposed to do this. However, when I run the macro it provides an error (3011) that shows the very first file it attempts to find is not in a valid path. The path is pointing to the personal folder of the person who sent the database to me. I've received similar databases before and had no problems using them once saved to my computer.

How can I make Access recognize the path is now my own computer and not the previous user? I've tried editing the macro in design mode but see no option for pointing to the needed files.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
899 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.