Microsoft Access

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

ScriptingGuy1 January 3, 2008 Jan 3, 2008 01/3/08

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 Hey, WK. Having been gone for nearly three weeks, ...

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

ScriptingGuy1 October 25, 2007 Oct 25, 2007 10/25/07

Hey, Scripting Guy! How can I trigger an alert if an Access database file exceeds a specific size?-- MA 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.” Note. The Scripting Guys...

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?

ScriptingGuy1 October 3, 2007 Oct 3, 2007 10/3/07

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 sample ...

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

ScriptingGuy1 July 10, 2007 Jul 10, 2007 07/10/07

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 Hey, MF. As you may or may not know, there’s a Microsoft researcher named Gordon Bell who has devoted his professional efforts to “...

How Can I Append a Value to a Specified Field For Each Record in a Database?

ScriptingGuy1 June 5, 2007 Jun 5, 2007 06/5/07

Hey, Scripting Guy! How can I add the letter s to the end of a specified field for each record in an Access database?-- A Hey, A. It’s day 2 of TechEd 2007 and the Scripting Guys are still sitting here in the CMP Media booth (that’s booth No. 1301 for those of you attending TechEd); they’re busy handing out copies of Dr. Scripto’s ...

Scripting Blog

Microsoft Access - Scripting Blog

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

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

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?

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

How Can I Append a Value to a Specified Field For Each Record in a Database?

PowerShell Resources

Topics

Archive