13. (Advanced Programming In Access 2013) Using ADO Command Objects

Using ADO Command Objects video in the "Advanced Programming in Microsoft Access 2013" series hosted by Steve Bishop. In this free advanced video tutorial series Steve will be going over Microsoft SQL Server installation, Database Migration, creating a better User Interface, using external data sources, complex Visual Basic For Applications (VBA) concepts and distributing your application.

Click here for the full playlist of "Advanced Programming in Access 2013":

Click here for the Work Files of this series:

[swapnilwankhede]

Excellent Tutorials, Thanks a lot Steve for uploading this videos, it’s really helpful, never
found such good videos.

[andersarvidsson]

Thanks a lot for all your videos, Steve. But there is a problem here. If I use the code in this video on a form and put a combobox on that form, then try to Set combobox.recordset=ADOrec immedeately after Set ADOrec=ADOCom.Execute I get error 7965 Object is not a valid record set property. How do I bound a ADO recordset that is calculated on a SQL Server to a combobox list?

[iskra]

Fantastic lesson! Greetings from Italy

[ChironStellar]

These are the best videos I've found concerning Access DAO/ADO instruction. Thank you Steve! I've noticed that you don't use the ".Close" method on any of the database objects. Do you find this isn't necessary?

[GodParticleZero]

Why when using execute to store the recordset does it give me an error about rowset not supporting fetching backward if i do rs.movelast?

[j.p.vincent]

Hi Steve, Thank you for your tutorials, they are realy, realy great :-) ! Do you have a video about uploading an Access table into a SQL Server table (1:1) via VBA? Uploading via a linked table goes very slow. Tnx!

[josejorgeduran]

I appreciate a lot your training and I had been learn a lot (sorry my very bad english). But I have a question: Can you describe an example using store procedures? Thanks in advance ...JJ

[AbulbatalBatal]

Thank you Steve. I tried both with return value and without. That why I changed the output to be a number but still no luck

[Icedgarr]

Hey Steve! Thanks a lot for all this tutorial, it is amazing and I am learning a lot.
However I would like you to ask something further on the line this video is going:

Supose that what we are trying to do is use the command to do an "Insert Into". In this case we want to insert into a table on our SQL Server Database from a Recordset selected from an Access table.
(If we were doing the whole process just in access it would be something like: "Insert into Table1(Field11, Field22) SELECT Field21, Field22 FROM Table2 Where 'Conditions' " but in this case table1 would be in a SQL server Database and Table2 in Access )

How could we write this Insert into command to make it work?

[jacquesleroux]

Hi thank you this was very useful, I am just getting into ADO recordsets and this helped me a lot. Do you have a video on working with record sets?

[atlantakick]

As always, thanks for the video. I was wondering how you were taught and how you continue to improve your programming skills. Other than the occasional $50 book most of what I find is not presented in a structured learning format like your videos are.

[Shallo]

Hi Steve,

Once I assign the ADO recordset to my form's(Datasheet Form) recordset, ain't able to edit the data even though i have the lock batch optimistic lock. Please shed some light on this.

Many Thanks

[coaching_engineer]

Did you add a time stamp to the Customers Table?

[ericc]

can you show us how to pass an array of values to sql stored procedure, and on that SP doing loop of insert update delete.