I need to know some simplistic details about how Microsoft Access' linked tables work. I think I know the answer, and this question is more about asking for a confirmation than anything else. A pointer to documentation would be appreciated, as well.
I am testing an Access ancillary application that pulls its data from a crime statistics Informix IDS database. The Access database contains several linked tables to the Informix database, and, using a multi-table query, updates a native Access table with information.
I am assuming if the network link to the Informix database breaks even for an instant, the linked tables' links also break, and the application must be reloaded. Is that assumption correct? I saw this happen when I let the application run overnight. The links were broken, and I believe the network link burped overnight.
The reason I'm asking this, is I have to build in a re-load mechanism into the Access form, so that the user does not have to close the application and re-open it.