Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Dragon55

    VB 6, MS Access 97 and ADO... what is best connection?

    With all due respect to kb244, I must take exception to his answer. Even though MS claims that ForwardOnly is the fastest cursor type, I have found that this is NOT always the case. Unfortunately, the only way to find out which is really the fastest access method in any particular situation is...
  2. Dragon55

    Why is ADO so much slower than DAO?

    Thanks for your input, mohmehran, but as you can see in the rs.open statement, it is opened as Static. And I didn't specify the LockType because adLockReadOnly is the default. As for the grid I'm using, it's the new DataGrid control, which definately accepts ADO data sources. I would expect...
  3. Dragon55

    Why is ADO so much slower than DAO?

    OK, I was able to get the time down to 16 seconds with the following code: Option Explicit Private cnWIP As ADODB.Connection Private rsWIP As ADODB.Recordset Private Sub Form_Load() Dim sConnStr As String Dim sSQL As String Set cnWIP = New ADODB.Connection Set rsWIP = New...
  4. Dragon55

    Why is ADO so much slower than DAO?

    I am considering upgrading my VB6 apps to use ADO and Jet4.0. I have always used the generic data control up till now. So I made an Access 2000 version of one of my (replicated) databases and tried several methods of accessing the table to be diplayed in a DataGrid. (31,000 records, 26 fields)...

Part and Inventory Search

Back
Top