automatically relinkt tables in access 2010 to SQL server 2012

[danieltaylor]

Hi to all...



I have an Access_fe linked to SQL_be. I copy the Access_fe and put it on a client computer. But the problem is i need to relink the table everytime i open the Access_fe. Is there anyway to automate the process of linking tables to SQL server???

Or maybe a way that the "SQL Log-in" form to pop-up immediately everytime i open my Access_fe

Thanks!!!

[June7]

This is a repeat topic of https://www.accessforums.net/access/...sql-30302.html