I am trying to create a button on a main menu form that when clicked on will automatically update all data of several linked tables (location of raw data is a single excel workbook with each table being represented by its own excel tab sheet. I know it can be done with a button per table/tab but is there a way to do all tables/tabs with just one command button.
or is there a way to have all of the data update automatically as soon as the access db is opened.
or is there a way to have all of the data update automatically as soon as the access db is opened.