All folks, thank you for your suggestions.
First of all, I will try to explain what I have done already and what problems I encountered.
1) I have a (Joomla!) website and a web application that maintains a membership table in the Joomal! database
2) I have an Access DB that links, via an ODBC Connector, in read-only to this membership table.
3) I have queries, reports, forms that use this connected table.
So far, so good. Queries and reports run very smooth. But:
1) Once in a while, I get an error on the ODBC connection and then I have to close the Access DB and start over again.
2) When I open the table (only about 1000 rows; 30 fields) and type a search argument (e.g. membership ID or name) to filter for a specific row, it can taken over an hour to get an answer.
I tried, as an alternative, to import the table instead of connecting.
This works perfect. No connection problems and filtering works at lightspeed (more or less).
The only side effect is that the table is not refreshed automatically when I open the Access DB and explaining to a non-IT user how to do this??? Nightmare!
So, that is the reason of my question: is there a way to write a macro or VBA to achieve this on open (or by a click on a button).
The suggestion of Shimon could be a valuable alternative for the performance but as the connection stays alive, I fear that this would not solve the connection errors.
Willy