Scripting Blog

A place to learn about PowerShell and share stories of automation

Microsoft Access - Scripting Blog

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (1/8/10)

January 8, 2010 Jan 8, 2010 01/8/10
ScriptingGuy1
In this post:   How Can I Read the Default Value of a Registry Key? Hey, Scripting Guy! You had a great post on Monday about setting the default value of a registry key. It is half of what has been bugging me lately. The other half is how to read the default value. I want to retrieve a string, but what I get is a ...

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (9/25/09)

September 25, 2009 Sep 25, 2009 09/25/09
ScriptingGuy1
Can I Find Out Who Has Access to a Group of Files and Folders? Hey, Scripting Guy!  For security reasons I need to find out who has access to a certain group of files and folders. Using the Get-Acl cmdlet, I can get a list of which IDs and groups have which kinds of access to the target files and folders. I would also like to list ...

Hey, Scripting Guy! Can I Query a Microsoft Access Database with a Windows PowerShell Script?

August 13, 2009 Aug 13, 2009 08/13/09
ScriptingGuy1
 Hey Scripting Guy! I have a Microsoft Access database that I need to query from a Windows PowerShell script. I have seen a number of VBScript examples, but I cannot find any Windows PowerShell samples. Can you point me in the right direction? I do not want you to write it for me, but I would like a hint.-- KS Hello KS, Microsoft ...

Hey, Scripting Guy! How Can I Import Data into Office Access from Office Excel?

February 19, 2009 Feb 19, 2009 02/19/09
ScriptingGuy1
Hey, Scripting Guy! I need to do hardware inventory on all our workstations and on all our servers. I know System Center Configuration Manager can do this and a whole lot more. We actually have it budgeted for deployment next year. However, that does not help me now. We had a summer intern that went around and typed a lot of information such...

Hey, Scripting Guy! How Can I Tell Which Tables and Columns Are in a Database Without Opening It?

February 18, 2009 Feb 18, 2009 02/18/09
ScriptingGuy1
Hey, Scripting Guy! Is there a way to figure out which tables and columns are in a database without having to open it up?- DT Hi DT, The Impressionists are back in Chicago! For the past six months, they were hibernating down in Ft. Worth, Texas, in the United States. But now they are back. In true Ferris Bueller style, I am standing here ...