I would like to run a query in the background so that the users don't even notice. My query will take almost a minute. I want the main form to pop up and allow the person do do certain things while this is running. I have no problem letting the user know that he cannot do other things until the query is run.
In order to speed up my application, I am running a query that takes the data from the server and populates a temporary table. This table is deleted when the person logs out, and it will be refreshed when they get back in.
I am not sure that the users will react well to a program that takes 1 minute to load even if it is a lot faster after that.
What can I do? My front end is in access, and my backend is also in Access and they have linked tables.
Thanks for your help.
In order to speed up my application, I am running a query that takes the data from the server and populates a temporary table. This table is deleted when the person logs out, and it will be refreshed when they get back in.
I am not sure that the users will react well to a program that takes 1 minute to load even if it is a lot faster after that.
What can I do? My front end is in access, and my backend is also in Access and they have linked tables.
Thanks for your help.
