JET pulling All Data from SQL Sever in a Query (1 Viewer)

[WindSailor]

I found an article on the internet on how to stop this, but for the life of me I can't remember it or find it.

The article stated that even though you were limiting your returned set of data from SQL Server by using a 'Where' clause etc. JET still pulled all of the data.

The solution has to reserve a read/write ability.

Can anyone expand on this?

Thanks.