When you run relink procedure at application startup, and backend file is located on the network – the process can be much slower then relinking local file, even with very fast network. The trick is to open backend file before relink process and close it after. Sample code:

Dim dbData  As DAO.Database Set dbData = DBEngine.OpenDatabase(strFileName) 'Relink proc follo   read more »