Showing archive results for 2006

Hey, Scripting Guy! How can I delete a record – or a set of records – from a disconnected recordset?-- SM eHy sm.,. Sorry; let’s try that again: Hey, SM. We apologize for the poor typing the first time around; the Scripting Guy who writes this column is trying to adjust to typing with just one hand and just one eye. Last night this Scripting G...

Hey, Scripting Guy! How can I provide a visual indicator of some kind when copying a large file or large set of files?-- SK Hey, SK. Before we do anything else we should note that the Scripting Guys – or at least the Scripting Guy who writes this column – don’t believe in moral victories. It’s nice that the University of Washington took USC – th...

Hey, Scripting Guy! How can I compact an Access database using a script?-- DA 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, “Compact an Access database? That sounds har...

Hey, Scripting Guy! How can I pass the drive letter of a drive from a VBScript script to the command shell that called that script?-- JF Hey, JF. You know, as kids grow up they pass through a phase where they believe that their parents are capable of doing – and of fixing – anything. Admittedly, children quickly learn the cold, harsh facts, but,...

Hey, Scripting Guy! How can I tell whether a specified table exists in a SQL Server database?-- LL Hey, LL. Well, as it turns out it’s absolutely impossible to tell whether a specified table exists in a SQL Server database. So, sorry, time to go back to watching the Major League Baseball playoffs. By the way, who else out there hates the Dodgers...