Yes the Same amount of data between SQL Server and Access.

I was testing how long it takes to pull the data.

The real extraction that I need is batch oriented and...

Thank you both for your replies.

I was afraid of the solution might be to set up each user in SQL Server as there is quite a few.

The only other solution...

No I am not joining any tables in the remote server.

I am just pulling a simple data extraction from remote server with where conditions....which is why I don't understand why...

Eric,

Your solution seem to work faster:

Exec ('Select ...) at linked Server

It took about 14mins...which is still longer than access but atleast it takes half the time of OpenQuery.

Thank you...

This particular table has about 500k rows of records and I am only pulling columns that I need.

Changing it from Temp Table to a make table in the database did...

Thanks dlaughlin 24148...will test it out and let you know.

No this is not something I will do on a regular basis...want to develop this so that I won't have to...