Richard has attended:
Access Advanced course
Using MS Access queries
Where I telework, the network speed is extremely slow. This affects me when I am trying to run MS Access queries.
How can I use MS Access to get round this? Is the use of make-table queries the best / only way round a slow network?
RE: Using MS Access queries
Hi Richard
Thank you for your question
Using a make table query would place a copy of a table on your lap top. You could then build queries on that, thus avoiding the need to connect remotely to the database.
The problem would be that the tables you create would be a snapshot of the data at the time you built them and would not necessarily represent the up to date data.
You might want to consider the method you use to connect when working remotely, and seek advice from your IT support.
Regards
Stephen