Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » Microsoft Access   (RSS)
Friday, September 25, 2009 12:01 AM

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (9/25/09)

Can I Find Out Who Has Access to a Group of Files and Folders? Hey, Scripting Guy! For security reasons I need to find out who has access to a certain group of files and folders. Using the Get-Acl cmdlet, I can get a list of which IDs and groups have
Posted by ScriptingGuy | 0 Comments
Thursday, August 13, 2009 12:01 AM

Hey, Scripting Guy! Can I Query a Microsoft Access Database with a Windows PowerShell Script?

Hey Scripting Guy! I have a Microsoft Access database that I need to query from a Windows PowerShell script. I have seen a number of VBScript examples, but I cannot find any Windows PowerShell samples. Can you point me in the right direction? I do not
Posted by ScriptingGuy | 0 Comments
Thursday, February 19, 2009 6:15 PM

Hey, Scripting Guy! How Can I Import Data into Office Access from Office Excel?

Hey, Scripting Guy! I need to do hardware inventory on all our workstations and on all our servers. I know System Center Configuration Manager can do this and a whole lot more. We actually have it budgeted for deployment next year. However, that does
Posted by ScriptingGuy | 1 Comments
Wednesday, February 18, 2009 6:15 PM

Hey, Scripting Guy! How Can I Tell Which Tables and Columns Are in a Database Without Opening It?

Hey, Scripting Guy! Is there a way to figure out which tables and columns are in a database without having to open it up? - DT Hi DT, The Impressionists are back in Chicago! For the past six months, they were hibernating down in Ft. Worth, Texas, in the
Posted by ScriptingGuy | 1 Comments
Tuesday, February 17, 2009 6:13 PM

Hey, Scripting Guy! How Can I Create a Database with More Than One Table?

Hey, Scripting Guy! Being able to create a database from a script is nice, and I appreciated your article yesterday. But I need to have a database with more than one table in it. Obviously this can be done, but I am at a loss as to how to go about it.
Posted by ScriptingGuy | 2 Comments
Monday, February 16, 2009 6:12 PM

Hey, Scripting Guy! How Can I Use Windows PowerShell to Create an Office Access Database?

Hey, Scripting Guy! I have looked everywhere, and I cannot find a script that will create a new Microsoft Office Access database, and automatically add a new table and columns to it. If you had such a thing in Windows PowerShell it would be even better.
Posted by ScriptingGuy | 1 Comments
Tuesday, April 03, 2007 5:45 PM

How Can I Save a Table in an Access Database as a Spreadsheet?

Hey, Scripting Guy! How can I save a table in an Access database as an Excel spreadsheet? -- OT Hey, OT. You know, we appreciate the question, but where were you last week, when we really needed you? The truth is, last week was excruciatingly dull, at
Posted by ScriptingGuy | 0 Comments
Monday, October 09, 2006 10:18 AM

How Can I Compact an Access Database?

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
Posted by ScriptingGuy | 0 Comments
Monday, October 02, 2006 11:30 AM

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

Hey, Scripting Guy! How can I use Windows PowerShell to pull records from a Microsoft Access database? -- SB 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!
Posted by ScriptingGuy | 0 Comments
Thursday, June 08, 2006 6:20 AM

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

Hey, Scripting Guy! How can I list all the tables in an Access database? -- KW 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,
Posted by ScriptingGuy | 0 Comments
Friday, October 07, 2005 7:18 PM

How Can I Determine Which Version of Access was Used to Create a Database?

Hey, Scripting Guy! How can I determine which version of Access was used to create an Access database? -- TW Hey, TW. You know, at least one of the Scripting Guys is a bit old-fashioned, to say the least. He doesn’t own a cell phone, and he won’t use
Posted by ScriptingGuy | 0 Comments
 
Page view tracker