I have a local table that I have placed records into that came from a linked SQL table. I am trying to query the linked SQL table that would have additional matching records. If it finds more than just the initial record I placed in the local table then I do additional things with these records. If it only finds the initial record I placed in the local table then I move to the next local record and continue until I reach the EOF in the local table. I am using 2 recordsets to loop through each table. The problem I am having is that when I am using the linked SQL table the recordcount always comes back as only 1 record but if I copy the linked SQL table and make it a local table it returns the correct recordcount.
So I am using the same data whether in a SQL linked table or in a local table but why would it be able to identify the correct record count in the local table and not the linked SQL table?