You can open a form to support the appropriate function when the accdb is loaded. There are two ways to do that, one using the AutoExec macro, the other by designating that form as the start-up form for the accdb.
If you have a switchboard or dispatcher form that gets launched then call from that form's OnLoad event. If you were using a macro it would probably need to do a RunCode action to call a function because macro RunCode action doesn't call subs, only functions.
NO HELP REQUIRED TODAY, IM JUST PROVIDING INFORMATION SO THAT OTHERS CAN USE. I have a split database with the tables in an Access database (2013) as the backend and all the forms and queries in another for the front end. The system will be distributed to various users on different setups for...
This allows you to import an Excel table, but also link it. Before linking, the existing link must be deleted.
How exactly does the new Excel table differ from the existing one?
If the name of the workbook and the name of the table are the same, you can simply overwrite the old workbook with the new workbook (=> same path), and the existing link will work without any further action.