Automatic linking of tables

Has anyone ever developed a routine or macro that allows automatic
linking of tables to the ODBC data source so as to not have to go
through the routine each and ever time? We used access to modify our
Packing list and are using ODBC to link to the files. For each user
who needs to print this pack list we would like this process
automated. Any ideas?