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

Hey, Scripting Guy! How can I list all the tables in an Access database?-- KW Hey, KW. You know, the best part about writing a daily column on system administration scripting is that people only see the finished result; they never see all the detours, dead-ends, and other frustrations we go through in order to produce that column. For example, p...

Hey, Scripting Guy! We have tons of text files in which each line in the file represents a record or an event of some kind. How can I use a script to retrieve records or events that occurred on a specified date?-- TW Hey, TW. You know, in your email you sort of apologized for using text files, noting that “I know, I know, we should probably use ...

  Hey, Scripting Guy! How can I save a disconnected recordset?-- RW Hey, RW. You know, the Scripting Guys believe in keeping things as simple as possible. For example, when one of the Scripting Guys had to buy a new tie several years ago, he simply asked his dad to tie it for him; on the rare occasions when this Scripting Guy has to wear a t...

Hey, Scripting Guy! In an Excel spreadsheet, how can I locate and replace information for a specific computer?-- BB Hey, BB. You know, there’s an old saying that goes, “If all you have is a hammer then everything looks like a nail.” Well, all we Scripting Guys have at the moment is some code for modifying a record in a database. So guess what: t...

Hey, Scripting Guy! How can I get a list of all the users who have an alternate recipient (altRecipient)?-- SA Hey, SA. You know, one of the great things about being a Scripting Guy is that we don’t ever have to know what we’re talking about; all we do have to know is how to write a script that does whatever it is you ask us to do and everyone’s...