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 […]
Archive for November, 2009
Add Access record
Posted by: | November 23, 2009 | No Comment |Adding a Table to an Access database
Posted by: | November 23, 2009 | No Comment |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 […]
Creating an Access database
Posted by: | November 22, 2009 | No Comment |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 […]
Windows 7 – Pet Hate #1
Posted by: | November 21, 2009 | No Comment |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 […]
WMICookbook: Read Routing Table
Posted by: | November 20, 2009 | 1 Comment |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 […]
Excel 2010 beta
Posted by: | November 19, 2009 | No Comment |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 […]
PowerShell v2 cmdlets
Posted by: | November 19, 2009 | No Comment |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
Office 2010 – fixed in beta
Posted by: | November 18, 2009 | No Comment |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 […]
Reminders via WPF
Posted by: | November 18, 2009 | No Comment |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 […]
Categories
- .NET
- Active Directory
- Architecture
- Azure
- Bash
- BITS
- Books
- CDXML
- CIM
- Cloud
- COM
- Containers
- Deep Dive
- Desired State Configuration
- DevOps
- DHCP
- DNS
- DSC
- European Summit
- Events
- Exchange
- File System
- Firewall
- General
- General IT Matters
- Hyper-V
- IIS
- Infrastructure
- IT Community
- IT Security
- Learning PowerShell
- Linux
- Math
- Microsoft
- Modules
- Nano Server
- Networking
- Office 2010
- Office 2013
- Open Source
- Opinion
- Outlook
- Philosophy
- PowerShell
- PowerShell 7
- PowerShell and .NET
- PowerShell and Active Directory
- PowerShell and CIM
- PowerShell and Exchange 2007
- PowerShell and IIS
- PowerShell and SQL Server
- PowerShell and WMI
- PowerShell Basics
- PowerShell original
- PowerShell Summit
- PowerShell User Group
- PowerShell User Group 2
- PowerShell v2
- PowerShell V3
- PowerShell v4
- PowerShell v5
- PowerShell v6
- PowerShell.org
- PowerShellGet
- PowerShellV2
- PSAM
- Rant
- Registry
- Scripting
- Scripting Games
- Scripting Games 2104
- Security
- SQL Server
- Storage
- Strings
- Summit
- Technology
- Uncategorized
- Virtualization
- Windows 10
- Windows 2012 R2
- Windows 7
- Windows 8
- Windows 8 Server
- Windows 8.1
- Windows Server
- Windows server 1709
- Windows Server 2008
- Windows Server 2008 R2
- Windows Server 2012
- Windows Server 2012 R2
- Windows Server 2016
- Windows Server 2019
- WMFv5
- WPF
- WSUS