performance - Access slow when joining on Teradata SQL connections? -

I have a simple access database I can use to create a number of reports. I've linked to the Teradata database server in our organization to draw some extra employee-level details. A simple number is left in the employee number, and whatever I pull is the name and role.

Connect without query will probably take a minute or two to run and loads a lot of time quickly. By joining the Teradata connection, slows down all the left under a crawl, it can take up to 10 minutes for the query to run through Excel. When the query is loaded in Access, it is very slow through the scroll.

I should pay attention to there is no display issues with Teradata server. I am the same, and joins the complex to obtain unrelated reports from different tables and the speed is very fast.

I tried to make an even easier query that is almost noticeable, and are still performing issues. Here's the code:

  select EMPL_DETAILS_CURR.NM_PREFX, EMPL_DETAILS_CURR.NM_GIVEN, MC.DT_APP_ENTRY, MC.CHANNEL_IND MC Join MC.EMP_ID = on EMPL_DETAILS_CURR EMPL_DETAILS_CURR.EMP_ID the left; In the   
  MC  are only recording 7000.   
 
 
 Microsoft's own local machine if you are involved in data between MS Access tables and Teradata tables But jet engine means that the data present in your teradata tables is being brought to the local machine so that it can be included.  
 If the table on Teratata and entered through templates linked to MS Access may still be occurring locally I query can forget ODBC Direct (i exact words) As such, to allow SQLite to pass SQL to execute and return to MS Access when the results are completed.