Yup - I fully understand - my intent was to walk you through, and explain, the code at whatever level of detail you desire - but first I wanted to get us both working off the same database and with functioning scripts. The connect string is just a shortcut for MSAccess - you shouldn't have to define an ODBC Data Source but if you've already got one - whats it called ?
The assumption in the above script was that you already had a database called app.mdb located somewhere on your workstation or on a share.
If you just want to learn more about OLE - we can work with other objects like IE or MSAgent. These objects don't have as many external dependencies.
Or are you specifically interested in OLEDB ?
I just figured it would pretty tough to explain how KIX OLE works, using objects that don't (work - that is).
Shawn.
