Database Search
TechHome
 | |
|
- !!! Simple ADO Example !!!
- !ADO Object Model
- 1255 OLE Member Not Found
- ADO - ADOX requirements
- ADO - DAO Constants
- ADO AD Sort Problem
- ADO and GetObject
- ADO and Large Numbers
- ADO Convert Access data to Tab Delimited Text File
- ADO CreateParameter
- ADO Data Control Constants
- ADO Data Shaping
- ADO Error Issue
- ADO Error Object
- ADO Find vs DAO Seek Access Example
- ADO Jet Order By Clause
- ADO links
- ADO Sample for Stored Procedure
- ADO SaveAs and Excel or Convert Before Closing
- ADO Schemas
- ADO softseek
- ADO SQLOLEDB Example
- ADO Stream Binary File Download
- ADO Stream to Binary Buffer
- ADO with mySQL
- ADOX Append Table Columns
- ADOX Grant Permissions
- ado_seek
- Auto Form For ADO Database Tables
- Auto Generate GUIDs
- Basic Database Dialog Sample
- Beginner ADO Question
- Check Who is Using an MDB
- Close an Active Connection
- Connect to SQL Server 2000 MSDE
- Converting Text String to 4-char Soundex String
- Create Address Book XML File
- Create ADO Get and Put UDFs for Selected Database Table
- Create an AutoIncrement Column in Access
- csv2acc - ADO - CSV-delimited to MDB conversion
- csv2acc2 - ADO - CSV-delimited to MDB conversion2
- DAO CreateTableDef
- Delete All Records from Access Table
- Error 1261 using SetInfo Method
- Extract Column Data Using ADO
- Generic Recordset to Text file UDF
- Get Create_date From SQL Server Table Properties
- Get Extended ADO Connection-Version Info
- Get Result Data of Select Statement
- Get Users Email Address in Active Directory
- GetRows Array Results Explained
- How to Filter Records
- Import Data into My SQL
- Insert Rows From One Database to Another
- Inserting Rows that Contain Apostrophe
- Large Database Query Example
- Learning ADO Conversion to Winbatch
- Lock Database in ADO
- Long Discussion on ADO and Creating a Table
- Microsoft Access Database Engine 2010 Redistributable
- MySQL UDFs
- OLE and DAO Example
- OLE DB Data Link Properties Dialog
- Ole Exception ADODB Recordset
- OLE Exception Connecting to Oracle ODBC Driver
- Ole Exception ParentCatalog ADOX
- Parent-Child Fabricated Recordsets
- Playing around with ADO Schemas
- Problem Getting Record Count via ADO
- Retrieve all user objects in a domain via ADO
- Return a Value from an ADO array
- Samples for creating ADO connections
- Simulate Alter Structure for Persisted XML Recordset
- SQL Server 2005 XML with Winbatch
- SQL Server Blank Password
- SQL Server Update Using ADO
- SQLOLEDB Provider Error
- Stored Procedure with Return Value
- Streaming Recordset To Browser
- Tip - Avoid Duplicate Errors in Bulk INSERTS
- Use ADO to Insert Data From CSV Into Excel
- Use the Datalinks Dialog to insert ADO Connection info into a script
- Very Basic Database - Dialog ADO Sample
- Visual ADO Connection
- Wildcard for SQL LIKE Using ADO
- Write BLOB to MySQL
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
ADO Find vs DAO Seek Access Example from a User
Keywords: ADO Find vs DAO Seek Access
Below is a link that includes the International Dialing table in ACCESS, and two scripts.
1 uses DAO. The OTHER ADO/OLE DB.
Also included are two text files which read in sample data to do a 'lookup' in the ACCESS table.
The DAO script uses the Seek() function, as the table in Indexed. It is pretty straight forward, and the output is displayed in Notepad.
The ADO Script uses the Supports() method to determine if the Provider supports Seek or Find then uses the appropriate one.
Note that Seek is Only supported with Office 2000 Access Databases (mine is 97).
What is more, seek is not supported for SQL Server or the MS Oracle Driver.
Microsoft (in the MSDN for Seek() ) says that the Jet 4.0 Provider supports seek, but my script tends to indicate the opposite - which you can see because the Output file indicates what is supported.
ADO Find seems to outperform DAO seek (which is and isn't surprising, as supposedly OLE DB utilizes an additional layer.).
There are comments as to where the values for the Supports() came from, and how the appropriate enum for the Recordset ( seek only works if a RecordSet is opened as a table, not a query or SQL Statement).
As always, comments and criticisms are welcomed and appreciated.
stan littlefield
stanl@btitelecom.net
Ado_dao.zip
Article ID: W14662
Filename: ADO Find vs DAO Seek Access Example.txt
File Created: 2017:08:29:11:58:40
Last Updated: 2017:08:29:11:58:40