Sorry, I had read so many of the posters I was focusing on what you said about verifying that the record was there via access which threw me off (it would be helpful to know which version of SQL Server you are running also 7.0?)... If running the same query using ISQL on your host server has the same failure, then you can verify that it is not the DBI or ODBC interface. Other than that, I would also try to see if M$ has updated ODBC drivers, or if you have the latest ones installed on the Server. Before you run off to Java, I would run a simple query using VB and and see if you get the same results...if you do.. then you can really point the finger at the DB. I built a DB with 1.2Million records... (sheese.. it took 30 mins - 1GB in size) and ran the same query... and it returned the records just fine. (Access however - I don't have MS SQL Server at home.) Only stuff I could think of. Good luck. JamesNC | [reply] |