Error message "The Microsoft Access database engine could not find the object...

Question

I have a macro which I run everyday to export data from a table to a csv file. The macro uses the 'ImportExportText' with a specification name to save the data to a specific filename. Today, when I run this macro, I'm getting the error message "The Microsoft Access database engine could not find the object '(here is gives the filepath and filename of the file I'm trying to save)'. Make sure the object exists and that you spell its name and the path name correctly..."

This macro ran fine yesterday, but today I'm getting the above message. I'm unaware of any system changes. I've tried to create a new macro from scratch, using the same Specification Name and same filepath as well as trying a new filepath, but continue to get the same error message. I do have the target filepath listed in the Trusted Locations (including subdirectories)

I have a 365 license so using the current version of MS Access.

Answer 1

Try exporting manually. Maybe that will give you a clue.
Also, see if you can re-export yesterday's data (maybe using yesterday's backup). If that succeeds, then it is likely related to unexpected data, maybe a Null value or a corrupt Memo (Long Text) field.

Answer 2

This was helpful. Doing the manual export I was able to identify the specific field which was causing the problem. Thank you.