I have an Access database with linked SQL Server tables. VBA code automatically loops through all linked tables and re-links them. However, when Access is an unstable state, I have had this procedure delete all links and not relink any of them. Is there a way to test to see if the re-link is successful and if not, abort the process and have a message box with the offending table. Thank you very much. I have attached a file with the VBA code.