Hi -
I have two database - TMP.accdb and NAV.accdb. The NAV.accdb links to the tables that are sitting the TMP.accbd. The 10 tables with thousands of rows that are in the TMP.accdb which are coming from an excel file in my input folder.
What I am trying to accomplish is when NAV.accbd is opened, the tables from TMP.accdb are updated to whatever excel tables are sitting in the input files.
Lets say the tables are named as follows:
TBL_15
TBL_25
TBL_35
TBL_45
TBL_55
TBL_65
TBL_75
TBL_85
TBL_95
TBL_105
I have updated the NAV database so my form called "Form1" opens when access is opened. I also updated a macro to run as Autoexec when the form is opened.
What I am having difficulty with is the code that runs when the NAV.accdbd is opened to delete the tables in TMP.accdb and update them with the newest versions of the 10 tables list above.
I don't know if deleting the tables and importing them into TMP.accbd is possible when opening NAV.accdb? Perhaps some other method is preferable than deleting and importing that is quicker?
Any advice to get this working but most importantly efficient and quick is certainly appreciated!
Thank you
Bookmarks