Richard Siddaway's Blog

We’ve seen how to create a database and a table. Now we need to know how to add a record to that table. 001 002 003 004 005 006 007 008 function Add-AccessRecord { param (     [string]$sql,     [System.Data.OleDb.OleDbConnection]$connection )     $cmd = New-Object System.Data.OleDb.OleDbCommand($sql, $connection)     $cmd.ExecuteNonQuery() } This takes a SQL INSERT statement and executes it against the table […]

  After reviewing the function I produced in the last post I realised i had made it over complicated.  I’m working with Office 2010 and 2007 predominantly so I should have the 2007 format as my default.  If I do that and change the switch parameter so it is used to create an Access 2003 […]

I’ve blogged a bit about using SQL Server with PowerShell, and using Word and Excel through PowerShell.  I realised that I hadn’t seen much about using Access. Access is part of the Office suite and is present on many desktops. It forms a handy data store for using with PowerShell. In this series of articles […]

I’ve been using Windows 7 since January and as I’ve reported several times I have been really happy with it.  One source of irritation has arisen – the Action Center. This is a reporting system for system issues such as security (firewall turned off) or maintenance (backups not configured).  This is fine but the thing […]

When we need to troubleshoot networking problems we will sometimes need to read the routing table on a machine. The routing table contains the information on the routes known to the network interfaces. This can be created automatically or manually . On the local machine we can use the route command to find this information […]

  The beta still allows those of us that aren’t in the USA to use the simple method of creating a new spreadsheet using PowerShell. 001 002 003 $xl = New-Object -comobject "excel.application"  $xl.visible = $true $xlbooks =$xl.workbooks.Add()   Makes life easier. In case you are wondering – if you don’t have your machine set to US English and you are using […]

Jonathan has started a series of posts at http://www.jonathanmedd.net/ on all of the new cmdlets in PowerShell v2.  If you are just starting with v2, or want more information on whats new, this is a good place to start. Technorati Tags: PowerShell v2,cmdlets

A couple of issues that I noticed with the Office 2010 TP have been fixed in the beta: Word documents will now download from the Internet and open One undocks back to normal view correctly I did notice that in the Visio 2010 beta the Window title still says Technical Preview.  All the other components […]

If I am working on my home machine I don’t necessarily have Outlook or any other application that gives me calendaring capability open. There are times when I need a simple reminder to do something. For some reason I always seem to have PowerShell open so I thought of using the eventing system to give […]

If I am working on my home machine I don’t necessarily have Outlook or any other application that gives me calendaring capability open. There are times when I need a simple reminder to do something. For some reason I always seem to have PowerShell open so I thought of using the eventing system to give […]