title: Microsoft Access Change Connection
body: <p>I am new on developing database using MYSQL as back-end and MS Access as the front-end,the server is installed on a linux machine Acer laptop which is also my daily driver, front-end testing is done in my Dell Windows laptop using MS Access. They are interacting because I whitelisted a ip added so that Dell can connect with the Acer Server.</p>
  <p>However when I got home and changed the wifi connection, I had redo the settings : whitelisted another IP to my server laptop because the previous connection is already not working at our house. Another problem is, on my MS Access File, the original connected tables is not working so I also have to make a new connection which resulted to MS Access importing another connection table that duplicated all of the tables from the previous set up.</p>
  <p>for Example : First set of tables are, employees_tbl, customer_tbl. But since I had to reconnect to another ip, i have now, employees_tbl, employees_tbl1, customer_tbl and customer_tbl1.</p>
  <p>Is there a way to avoid this? I know in programming, all you need to do is to change the configration variables esp ip. But here in access, seems like it is harder to change IP and retain initial connected tables.</p>
  <p>thanks for the help in advance.</p>