I wrote a VB6 application that connects to a SQL server (7.0) using an ADO data control. I placed two text boxes on the form and bound them to the ADO control. I have two table on the SQL server One called tMaster that has 10 records and an identical table called tMaster2 with 33,000 records. I start the VB application and first connect to the table with 10 records. It is very fast. I then change the recordsource to tMaster2 and start the application. I have to do a control+Alt+Delete because it hangs. It is doing something because I can see my harddrive light moving. It takes 5 minutes just to pull back 5,000 records using Query Analyzer.

My network Admin just came back from SQL training and is telling me that I should not try to pull back that many records.

Question:
#1.Does the ADO data control have to pull all the data accross the line? I would think that when you want to move from one record to the next you would be doing it at the server and not at the client??

#2. I can take the same tMaster2 table with 33,000 records and put them in an Access database on a novell server and change the ADO control in the same VB application to point to the access table. It is very fast.

#3. Does this sound normal. I just can't believe you would have the option in the ADO control to select a table if you couldn't pull it back????