Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

ActiveX Data Objects (ADO) - Scripting Blog [archived]

Hey, Scripting Guy! How Can I Use a Disconnected Recordset in Windows PowerShell?

February 15, 2008 Feb 15, 2008 02/15/08
ScriptingGuy1
(image) Hey, Scripting Guy! How can I use a disconnected recordset in Windows PowerShell? I’m able to create the recordset without any problem, but I can’t figure out how to reference the fields and values in that recordset.-- JVDL(image) (image) (image) Hey, JVDL. Well, we must say, we’re impressed by how cool, calm, and collected ...

Hey, Scripting Guy! How Can I Add a Record to a Database Using Windows PowerShell?

January 15, 2008 Jan 15, 2008 01/15/08
ScriptingGuy1
(image) Hey, Scripting Guy! Awhile back you showed us how we could use Windows PowerShell to retrieve data from a Microsoft Access database. I’m now trying to add data to a database using PowerShell, but I can’t get the script to work. Any chance you could show me how to add a record to a database using Windows PowerShell?-- AB(image) (...

How Can I Find All the Files in a Directory Tree that Contain a Specific Word or Phrase?

August 28, 2007 Aug 28, 2007 08/28/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I find all the files in a directory tree that contain a specified phrase?-- PB (image) (image) (image) Hey, PB. OK, so picture this: for the first time in a couple of months, the Scripting Guy who writes this column and the Scripting Son are playing basketball. The Scripting Son has a comfortable lead, ...

How Can I List All the Fields and Data Types in an Access Database?

July 10, 2007 Jul 10, 2007 07/10/07
ScriptingGuy1
(image) Hey, Scripting Guy! In a previous column you showed us how to list all the tables in an Access database. How can I list all the fields in those tables, along with the data type of each field?-- MF (image) (image) (image) Hey, MF. As you may or may not know, there’s a Microsoft researcher named Gordon Bell who has devoted his ...

How Can I Add a User to a Group If I Don’t Know the Distinguished Name of That User?

November 20, 2006 Nov 20, 2006 11/20/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I add a user to an Active Directory group if I don’t know the distinguished name of that user?-- VO(image) (image) (image) Hey, VO. You know, if we wanted to take the easy way out here we’d just tell you, “Sorry, but if you don’t know the distinguished name of the user you can’t add that user to ...