Technology61 mins ago
Pass Through Query from MS Access to SQL Server 2000
I am trying to run a pass through query from access to update a table in SQL Server, the query requires a join from the SQL table to a table in Access. I cannot seem to get the query to recognise the Access table, does anyone know the code to be able to do this. I am trying to speed up the process instead of using a linked table which is quite slow.
No best answer has yet been selected by TheUnderTow. Once a best answer has been selected, it will be shown here.For more on marking an answer as the "Best Answer", please visit our FAQ.