I have a database where all the data were coming from various excel workbooks in different locations. I have this problem where an error occur once I refresh my excel where the database is connected or the database itself. And it seems like some of the workbooks has been changed the filenames, delete the excel file and create a new one and moved the file in other locations. Is there any solution to prevent this error in the future?

Also, how do I know what file has been changed that results to this error? Now, I will check all the links to determine which has error which caused me much time to check what's going on in this database.

"The query did not run, or the database table could not be opened.

Check the database server or contact your database administrator. Make sure the external database is available and hasn't been removed or reorganized, then try the operation again."