Showing results for Microsoft Access - Scripting Blog [archived]

Jan 15, 2008
1
1

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

ScriptingGuy1
ScriptingGuy1

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 Hey, AB. Before we start ...

Scripting Guy!Windows PowerShellOffice
Jan 3, 2008
0
0

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

ScriptingGuy1
ScriptingGuy1

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, the Scr...

Scripting Guy!VBScriptOffice
Oct 25, 2007
0
0

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

ScriptingGuy1
ScriptingGuy1

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’ favorit...

Scripting Guy!VBScriptOffice
Oct 3, 2007
0
0

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
ScriptingGuy1

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 record for e...

Scripting Guy!VBScriptOffice
Jul 10, 2007
0
0

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

ScriptingGuy1
ScriptingGuy1

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 “lifelogging,” an a...

Scripting Guy!VBScriptOffice