[dba-SQLServer] ADO

You should get the MDAC SDK  ADO help files ado260.chm
Available from downloads area at
http:\\www.microsoft.com/data
maybe available on WinXP by default so check first.
Not sure if there are higher help versions for MDAC 2.8 or uses same name.

It Installs to here, I then create a desktop shortcut
C:\Program Files\Microsoft Data Access SDK\Docs\ado260.chm

Open up tree menus ADOProgrammersReference-->ADO API reference
                               --> ADO Code Examples --> Visual Basic 
Examples

Methods Code examples

AddNew Method Example
Append and CreateParameter Methods Example
AppendChunk and GetChunk Methods Example
BeginTrans, CommitTrans, and RollbackTrans Methods Example
Cancel Method Example
Clone Method Example
CompareBookmarks Method Example
ConvertToString Method Example
CopyRecord, CopyTo, and SaveToFile Methods Example
CreateRecordset Method Example
Delete Method Example
DeleteRecord and MoveRecord Methods Example
Execute, Requery, and Clear Methods Example
Find Method Example
GetRows Method Example
GetString Method Example

or this one not as useful for vba unless working with SQL Sever from SQL 
BOL download
C:\Program Files\Microsoft SQL Server Books Online\1033\adosql.chm

Francisco Tapia wrote:

>Daren,
>With ado, you can insert a new row item by using the .ADDNEW method...
>examples can be found here:
>http://devguru.com/technologies/ado/8669.asp
>
>more on ADO...
>http://devguru.com/technologies/ado/home.asp
>
>
>
>On 9/25/05, Darren DICK <darrend at crhorizons.com.au> wrote:
>  
>
>>Hi All
>>Can someone give me a quick rundown on the INSERT andUPDATE abilities
>>using
>>ADO
>>I vaguely remember the differences between ADO and DAO INSERT and UPDATE
>>etc
>>were substantial
>>
>>Many thanks
>>
>>Darren
>>
>>_______________________________________________
>>dba-SQLServer mailing list
>>dba-SQLServer at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>>http://www.databaseadvisors.com
>>
>>
>>    
>>
>
>
>--
>-Francisco
>http://pcthis.blogspot.com |PC news with out the jargon!
>http://sqlthis.blogspot.com | Tsql and More...
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada