Browse Blog Posts by Tags

All Tags » Access (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

View Access table definitions

We’ve looked quite a bit at how we can work with Access databases but how do we investigate the structure of the database. The first thing we need to know is the tables in our database 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 function Get-AccessTableDefinition...

Posted to Richard Siddaway's Blog by RichardSiddaway on Wed, Feb 3 2010
Filed under: Filed under: PowerShell V2, Office 2010, Access
Getting Access table definitions

So far we have only created a single table but in a database with a number of tables we need to be able to view the table definitions. 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 ## ## connect to database ## $conn = New-Object -ComObject ADODB.Connection...

Posted to Richard Siddaway's Blog by RichardSiddaway on Fri, Jan 15 2010
Filed under: Filed under: PowerShell V2, Office 2010, Access
Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'

No doubt that the error on subject line will get no where! This is presented when trying to open a Database Properties using SQL Server Managment Studio, going back to history on the SQL instance where this is presented is an upgraded database instance...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jan 12 2010
Filed under: Filed under: sql server, ssms, error, access, system, path, management studio, dll, sp_configure, registered
Delete an index

We have seen how to add indexes. We also need to be able to remove them 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 function Remove-AccessIndex { # .ExternalHelp Maml-AccessFunctions.XML [ CmdletBinding ( ) ] param ( [string] $table , ...

Posted to Richard Siddaway's Blog by RichardSiddaway on Sun, Jan 10 2010
Filed under: Filed under: PowerShell V2, Office 2010, Access
Access Indexes Part 1

We have some data in our table – now we need to think about indexing it 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 function New-AccessIndex { # .ExternalHelp Maml-AccessFunctions.XML [ CmdletBinding ( ) ] param ( [string...

Posted to Richard Siddaway's Blog by RichardSiddaway on Wed, Jan 6 2010
Filed under: Filed under: PowerShell V2, Office 2010, Access
Creating External help

In the previous post I included a line # .ExternalHelp Maml-AccessFunctions.XML in the Add-AccessRecord function. I have used comment based help in the past but as James found http://blogs.technet.com/jamesone/archive/2009/07/24/powershell-on-line-help-a-change-you-should-make...

Posted to Richard Siddaway's Blog by RichardSiddaway on Tue, Jan 5 2010
Filed under: Filed under: PowerShell V2, Modules, Office 2010, Access
Modifying the Add-AccessRecord function

As we discovered last time we need to alter the Add-AccessRecord function to enable us to define the fields as well as the values. 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 function Add-AccessRecord { # .ExternalHelp...

Posted to Richard Siddaway's Blog by RichardSiddaway on Tue, Jan 5 2010
Filed under: Filed under: PowerShell V2, Office 2010, Access
Change Autonumber start

For some reason the autonumbering has got out of synch. Maybe you already had data in the table and it wants to start at 1 or you’ve deleted a bunch of data and want to re-use some of the values. 001 002 003 004 005 006 007 008 009 010 011 012 013 014 ## reset the Autonumber function to...

Posted to Richard Siddaway's Blog by RichardSiddaway on Mon, Jan 4 2010
Filed under: Filed under: PowerShell V2, Office 2010, Access
Access – Autonumbering columns

One thing we often want in our database table is a column that will automatically increment itself when a new record is added. This makes a good primary key for the table as it is guaranteed to be unique. In this post http://msmvps.com/blogs/richardsiddaway/archive/2009/12/10/add-a-column-to-an...

Posted to Richard Siddaway's Blog by RichardSiddaway on Mon, Jan 4 2010
Filed under: Filed under: PowerShell V2, Office 2010, Access
My Analyzer ... the ultimate Data Dictionary Tool

My Analyzer ... the ultimate Data Dictionary Tool by Crystal Long, fellow Access MVP With Crystal’s analyzer in your toolkit, you can get a handle on what you have in Access ... structure, relationships, and data. It is, without a doubt, the most important set of programs she...

Posted to Tony's Microsoft Access Blog by Tony on Fri, Dec 25 2009
Filed under: Filed under: Access
Access Functions

I have put the module of Access functions I’ve been blogging about over the last few weeks onto my SkyDrive at http://cid-43cfa46a74cf3e96.skydrive.live.com/browse.aspx/PowerShell%20Scripts/AccessFunctions The file is alos attached to this post. The usual warnings apply. This is a work in progress...

Posted to Richard Siddaway's Blog by RichardSiddaway on Fri, Dec 18 2009
Filed under: Filed under: PowerShell V2, Office 2010, Access
Delete Access Table

This times lets go mad and delete a whole table. 001 002 003 004 005 006 007 008 009 010 011 function Remove-AccessTable { [ CmdletBinding ( SupportsShouldProcess = $true ) ] param ( [string] $table , [System.Data.OleDb.OleDbConnection] $connection...

Posted to Richard Siddaway's Blog by RichardSiddaway on Fri, Dec 11 2009
Filed under: Filed under: PowerShell V2, Office 2010, Access
Delete an Access Column

We have seen how to add a column to our access database – what about removing a column? 001 002 003 004 005 006 007 008 009 010 011 012 function Remove-AccessColumn { [ CmdletBinding ( SupportsShouldProcess = $true ) ] param ( [string] $table , ...

Posted to Richard Siddaway's Blog by RichardSiddaway on Fri, Dec 11 2009
Filed under: Filed under: PowerShell V2, Office 2010, Access
Add a column to an Access Table

Now we have created our Table we can start adding columns 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061...

Posted to Richard Siddaway's Blog by RichardSiddaway on Thu, Dec 10 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
New Access Table

I have already presented a function to create a new access table but I wasn’t very happy with it because we had to supply the full table creation SQL script. I have altered that function so it creates an empty table. We can then use the Add-AccessColumn function to add columns. This also means I have...

Posted to Richard Siddaway's Blog by RichardSiddaway on Thu, Dec 10 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Access Bulk Load data

We have already seen how to load individual records into an Access Table. Sometime we require the ability to add multiple records. We can easily adapt the way we use our Add-AccessRecord function to accommodate a bulk load scenario. Lets create a csv file with the information FirstName,LastName...

Posted to Richard Siddaway's Blog by RichardSiddaway on Fri, Dec 4 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Working with Access dates

Following on from the previous post about updating records one data type that will be a little awkward to work with is dates. If you use a US locale or any other that uses a date format of Month/Day/Year you can more or less ignore this because your standard formats work OK. If I run PS> Get-AccessData...

Posted to Richard Siddaway's Blog by RichardSiddaway on Mon, Nov 30 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Updating Access data

The last of of our data manipulation tasks is to update the data – we have already seen how to create, read and delete. 001 002 003 004 005 006 007 008 009 010 011 012 013 function Set-AccessData { [ CmdletBinding ( SupportsShouldProcess = $true ) ] param ( [string...

Posted to Richard Siddaway's Blog by RichardSiddaway on Mon, Nov 30 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Testing Connection to Access database

Many of the functions we have created so far have taken a connection to an Access database as a parameter. At the time we pass in the connection we don’t actually know if the connection is open. Test-AccessConnection can be used to test the connection before we use it. All we do is test the...

Posted to Richard Siddaway's Blog by RichardSiddaway on Sun, Nov 29 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access
Removing Access Records

So far we have seen how to add data to a table in an access database – now we want to delete some records. This is an action that can cause problems especially if we get the wrong records – ideally we want to a mechanism to check what we are doing. The PowerShell cmdlets that change system...

Posted to Richard Siddaway's Blog by RichardSiddaway on Sun, Nov 29 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010, Access

Page 4 of 15 (283 items) « First ... < Previous 2 3 4 5 6 Next > ... Last »

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.