Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

Microsoft Access - Scripting Blog [archived]

Hey, Scripting Guy! How Can I Add a Record to a Database Using Windows PowerShell?

January 15, 2008 Jan 15, 2008 01/15/08
ScriptingGuy1
(image) Hey, Scripting Guy! Awhile back you showed us how we could use Windows PowerShell to retrieve data from a Microsoft Access database. I’m now trying to add data to a database using PowerShell, but I can’t get the script to work. Any chance you could show me how to add a record to a database using Windows PowerShell?-- AB(image) (...

Hey, Scripting Guy! How Can I Delete a Set of Records From an Access Database?

January 3, 2008 Jan 3, 2008 01/3/08
ScriptingGuy1
(image) Hey, Scripting Guy! We have an Access database that we use to keep track of resources that are associated with all of our projects. Periodically I need to go into the database and delete all the records tied to a particular project. Is there any way that I can do that using a script?-- WK(image) (image) (image) Hey, WK. Having been...

Hey, Scripting Guy! How Can I Be Notified if an Access Database File Exceeds a Specific Size?

October 25, 2007 Oct 25, 2007 10/25/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I trigger an alert if an Access database file exceeds a specific size?-- MA(image) (image) (image) Hey, MA. You know just the other day Microsoft.com posted 100 Reasons You'll Be Speechless, a Web page listing 100 reasons why “Seeing Windows Vista for the first time may leave you searching for words...

Hey, Scripting Guy! How Can I Retrieve the Field Size and a Sample Record For All the Tables and Fields in an Office Access Database?

October 3, 2007 Oct 3, 2007 10/3/07
ScriptingGuy1
(image) I recently read an article of yours that showed me how I can retrieve the names of all the tables in an Access database, along with a list of all the fields in each table and the data type of each of those fields. That’s a really useful script, but it would be even more useful if it could list the field size and also display a ...

How Can I List All the Fields and Data Types in an Access Database?

July 10, 2007 Jul 10, 2007 07/10/07
ScriptingGuy1
(image) Hey, Scripting Guy! In a previous column you showed us how to list all the tables in an Access database. How can I list all the fields in those tables, along with the data type of each field?-- MF (image) (image) (image) Hey, MF. As you may or may not know, there’s a Microsoft researcher named Gordon Bell who has devoted his ...