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

Hey, Scripting Guy! How can I tally items in a text file?-- JA Hey, JA. If we understand you correctly you have a text file that consists of a number of lines, each line representing a particular item. Just to keep things simple, let’s say your text file consists of city names:City Seattle Seattle Los Angeles Chicago Seattle Los Angeles Pittsbur...

Hey, Scripting Guy! How can I use ADO to open a text file that has spaces in the file name?-- TL Hey, TL. You might not even remember sending us this question; to say it’s been awhile would be an understatement. (You should have seen all the dust and cobwebs we had to brush off this question before we could post it in the Script Center.) A long ...

Hey, Scripting Guy! Can I delete a table from a Jet database using a script?-- AK Hey, AK. Of course you can delete a table from a Jet database using a script; after all, you can do anything using a script! Well, OK, maybe not DHCP server stuff. And maybe you can’t change the display resolution of your computer. And maybe not - well, let’s just ...

Hey, Scripting Guy! Is there any way to get a list of all the user accounts in Active Directory?-- CB, Fremont, CA Hey, CB. By far the quickest and easiest way to do this is to search Active Directory for all your user accounts. Here’s a sample script that searches the fabrikam.com domain; to search your own domain, just edit the LDAP connection s...