I created a blank database and linked to a few tables from a secure database, in order to let users access some custom queries and reports. However, I find that the linked tables do NOT update automatically each time a query or report is clicked, the user has to open the tables in order to refresh them.
Why is this happening? Aren't linked tables supposed to refresh automatically every time?
Note: the source database is on a server location mapped to the local PC and does not require any password prompting.