When you connect to remote servers, always use tables attached to theserver through Access. This will significantly speed up your retrievaltime. Once a table is attached to a remote server, the whole structureof the table is brought down to your local machine. If it is not attached,the table structure is brought down the line, followed by your data, everytime you make a query.