Automatically add a linked table in frontend database when a new table is added in backend access database

[abyshek]

Hello Gurus,

I have a setup where a backend MS access database is stored in a server location. I have distributed copies of a frontend database with tables linked to the backend. Many times, I need to add new tables to the backend database. Is there a way in which I can automatically refresh the frontend so that a new table appears which is linked to the newly added table in the backend database? Or will I need to do it manually and send across a new copy of the frontend database?

Any help on this will be highly appreciated. Thank you so much everyone for all the help you provide..

 

[welshgasman]

I would just use an FE Updater and issue a new FE when changes are made, even new tables in the BE.
Some just use a shorcut, which copies the FE every time the shorcut is used to open the DB.