Scripting Blog [archived]

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

Microsoft Access - Scripting Blog [archived]

How Can I List All the Access Database Files on a Computer?

December 15, 2006 Dec 15, 2006 12/15/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I list all the Access database files (.mdb and .ldb files) on a computer?-- MG(image) (image) (image) Hey, MG. You know, in this day and age most people don’t believe in Santa Claus. Well, we happen to know that these people are wrong: Santa Claus really is real. How do we know that? Because he’s spent...

How Can I Print a Microsoft Access Report?

October 20, 2006 Oct 20, 2006 10/20/06
ScriptingGuy1
 (image) Hey, Scripting Guy! How can I print a Microsoft Access report?-- RW(image) (image) (image) Hey, RW. You know the cool thing about being a Scripting Guy – aside from the opportunity to pal around with Paris and Nicole – is the fact that people think we know what we’re doing. Someone asks a question like, “How can I ...

How Can I Compact an Access Database?

October 9, 2006 Oct 9, 2006 10/9/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I compact an Access database using a script?-- DA(image) (image) (image) Hey, DA. We have to tell you the truth: we are thrilled and excited about getting the chance to answer your scripting question. To be honest, that isn’t always the case, most days we’d look at a question like this and think, “...

How Can I Use Windows PowerShell to Pull Records From a Microsoft Access Database?

October 2, 2006 Oct 2, 2006 10/2/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I use Windows PowerShell to pull records from a Microsoft Access database?-- SB(image) (image) (image) Hey, SB. You know, you’re lucky to get this question answered; after all, this looks as though it’s going to be the very last Hey, Scripting Guy! column ever. To be honest, that came as a bit of a ...

How Can I List All the Tables in an Access Database?

June 8, 2006 Jun 8, 2006 06/8/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I list all the tables in an Access database?-- KW(image) (image) (image) Hey, KW. You know, the best part about writing a daily column on system administration scripting is that people only see the finished result; they never see all the detours, dead-ends, and other frustrations we go through in order ...