Again, informative. Is there a way to link to another front end that may hold custom functions, queries, and reports to use as a common library without registering the front end?
I'm not sure I understand the "without registering the front end" aspect, but this is what Library Databases are for. Take a look at: www.devhut.net/ms-access-library-databases/ Also, you can add the Library Database dynamically at runtime should you wish to. So, only register it at runtime.
Love your content, thank you very much! One question though, Is there any way to only refresh the link to SQL Server link tables/views and keep the applied index instead of recreating through VBA? For-example I have around 500 SQL server objects and would like to refresh / relink tables without re-creating indexes, something like when you right-click on the object in the navigation pane and select [Refresh Link].
Again, informative.
Is there a way to link to another front end that may hold custom functions, queries, and reports to use as a common library without registering the front end?
I'm not sure I understand the "without registering the front end" aspect, but this is what Library Databases are for. Take a look at: www.devhut.net/ms-access-library-databases/
Also, you can add the Library Database dynamically at runtime should you wish to. So, only register it at runtime.
Love your content, thank you very much! One question though, Is there any way to only refresh the link to SQL Server link tables/views and keep the applied index instead of recreating through VBA? For-example I have around 500 SQL server objects and would like to refresh / relink tables without re-creating indexes, something like when you right-click on the object in the navigation pane and select [Refresh Link].
Can you not loop through the TableDefs and perform a RefreshLink on each TableDef?