Thanks for your input, but I wrote this in a bit of a hurry, and perhaps didn't write all the information I had. The TransactionID is a primary key, and I can see all the record via both Access and the SQL Server Enterprise Manager. As i said, I know there are well in excess of 1 million records.
The stinger is that I wrote the equivalent code using Win32::ODBC and got the same results.