At work, I have a MS Access database I "inherited" managing and updating from someone who only used macros (database built in 2014). We have several users all with their own FE applications. All applications & Excel programs have trusted locations set and macro settings are enabled. We all work remote and connect to a remote desktop server (RDS). All of us have our application stored in our own folder within the users folder. Today, one user started to get a Single Step Macro Runtime Error 2001 when any report he tried to run got to the run code in the macro where it was to transfer the data to an Excel file. I can log onto the RDS, open up his folder in file explorer, then open the application he opens and run the reports with no issues. I have googled but I can't find anything close to this for finding a solution. I read about registry issues but our IT assures me that we'd all have that problem on a RDS. I've read that MS Office is corrupt and needs to be repaired but again IT assures me that would mean more of us would have an issue since we're sharing the application with separate user licenses. Just hoping someone on here might know something more about this runtime error for where it's happening. Thank you!