I have a Split Database. My backend database had access tables and some tables linked to an ODBC source. My front end utilizes all these tables. At this time my front end has queries that put the information together for my forms.

My problem is that the ODBC linked table slows down performance considerably. I'm wondering how to make the server do all the queries. My thought was to put a make-table or update-table type query on the server so that I make a continually update an Access table that I can link to from my front end. I'm thinking that this might speed things up on the front end.

Any comments and ideas on how to do this? I'm not sure how to make a query run in intervals, say every 5 minutes. And if I do this, will it slow everything else down?

You don't say what kind of server is involved.

If all tables are native to the server, the server will perform the query. However, with any Access table in the query Access does the query and must import all rows from the server table(s) into Access. This can be a killer with very large tables and the query may never complete on the Access side.