- Microsoft SQL Server 2005 Service Pack 2 SQL Server 2005 SP2 includes significant enhancements to maintenance plans, including an enhancement that lets users specify the cleanup interval in hours. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP2.
- How To: Determine the version of SQL Server 2005 Integration Services
- How To: Use Excel Services as a data source in Microsoft Office PerformancePoint Server 2007 Monitoring and Analytics
Wednesday, October 24, 2007
- 2007 Office System Sample: Setting Up a Development Environment This code sample accompanies the MSDN technical article Setting Up a Development Environment for the 2007 Microsoft Office System.
- 2007 Office Sample: Using the Office Open XML Formats to Support Electronic Health Records Portability and Health Industry Standards
- 2007 Office Document: Open XML Markup Explained
Wednesday, October 17, 2007
If you say need to print an Access report by 10:00 every Friday morning, you don’t have to do it manually. Follow this great tip from Tech Republic's Mary Ann Richardson.
This How To shows you how to add an add-in to an Access 2007 deployment package using the Package Solution Wizard, containing your application, the Microsoft Office Access 2007 Runtime, and additional files.
Additional links:
This Microsoft Office 2007 Portal provides a comprehensive set of servers, clients, and tools to make it easier for enterprises, software vendors, and developers to build and deploy a new class of business applications called Office Business Applications (OBAs).
. FIX: An access violation may occur intermittently when you run an Integration Services package that contains a Data Flow task in SQL Server 2005
. FIX: On a computer that is running SQL Server 2005 and that has multiple processors, you may receive incorrect results when you run a query that contains an inner join
Monday, October 08, 2007
Download a visual interactive reference guide to help you find Access 2003 commands in the new Access 2007 Ribbonbars.
You can also download the Access Ribbon mapping workbook, an Excel file that lists the commands on each tab of the Access 2007 Ribbon and the menu/toolbar location in previous versions of Access. Instructions on the first tab of the workbook provide tips for customizing, finding, and printing data.
Sunday, October 07, 2007
Protect Your Access MDE'sI was reminded today of the security leaks that exist in MDEs. While the VBA code is stripped, declarations and procedure stubs are retained in the MDE file, and object designs can be hacked.
There are some on the Web, who should know better, selling so-called MDE unlockers and protectors. Ethically, there are two issues here:
- These apps are marketed as protection aids, but they can also be used by the unscrupulous to do the opposite: get past MDE protection of someone else's database.
- How these apps do what they do is not a secret and can be done by anyone with retail Access. If you want to improve the protection of your MDEs or you genuinely need to get into one of your MDE's, before spending any money on these products, read on.
Did you know that:
1. You can access the Start-Up properties (such as disabling the Shift key bypass) of an MDE through another MDB and change each property.
2. You can open an unsecured MDE with the Shift key, press Ctrl+G to open the Debug window, press F2 to open the Object Browser, and then search all the code modules for procedure stubs, declarations, and constants.
3. You can import all the form and report objects but not the code from an unsecured MDE into an MDB.
Securing An Access Database
To effectively secure an Access MDB you MUST demote the Admin user from the Admins group. Otherwise your database will not be secure, as Admin cannot be removed from the Users group, and anyone using the retail system.mdw file logs on automatically as Admin.
1. Use the Access Workgroup Administrator (AWA), wrkgadm.exe, to create a new workgroup (.mdw) file.
2. Join the new workgroup using the AWA.
3. Make a backup copy of your MDB.
4. Open Access and the database to be secured.
5. Using Tools, Security, User and Group Accounts..., in the User and Group Accounts dialog:
5.1 Create a password for Admin user.
5.2 Create a new user account. This account will be the new database owner account. For example, call the owner account DBOwner. Add "DBOwner" to all groups, including the critical Admins group.
5. Close and re-open Access, logging on as "DbOwner", and leaving the password blank, as you have not assigned one yet.
7. In the User and Group Accounts dialog, demote the Admin user account by removing it from the Admins group. Now Admin is only a member of the Users group and will have only those permissions assigned to that group by "DBOwner".
8. Create a password for "DBOwner".
9. Close and re-open Access, logging on as "DBOwner" using the password you created in step 8.
10. You can now start to secure the objects in you database.
11. In Access 2000 and later, you also need to additonally secure your code by using Password Protection in the VBA Editor.
Special Notes:
- You don't have to distribute your MDW file with your MDE to protect it using this method
- A User account inherits the permissions of the Group to which it belongs.
I have tested an MDE protected with Access security and Password Protection in the VBA Editor with the demos of these two products: Access MDE Unlocker and Access MDE Source Protector, and both products failed to unlock the MDE.
You should test your own MDEs before distribution.
Caveat:
There is no bullet-proof protection against an expert hacker.
Saturday, October 06, 2007
This white paper discusses the benefits of deploying Microsoft Office 2003 Service Pack 3 (SP3) before upgrading to the 2007 Microsoft Office system, and details improvements to security and user experience.
Wednesday, October 03, 2007
I was never a fan of the RibbonBar gui in Office 2007, but was ready to accept the need to work with it.
But at each step in the learning process , there is nothing but frustration. And I am not alone: read the comments to a post on the Access Team Blog.
A partial random list of annoyances:
- There is no way to build or even review RibbonBars natively in Access 2007.
- The XML for a RibbonBar does not parse in MS XML Notepad or by using the MSXML dlls - the XML needs to be modified to be read.
- Using more than one period (.) in a row in a label breaks the XML.
- There is no easy way to get the ImageID of a native image: you have to download an obscurely located Excel file.
- The MS Custom Office UI Editor returns malformed XML errors by referring to the line and character number, but - you guessed it - the Editor screen has neither.
- There is next to nothing on customizing the RibbonBar in the Access Help file. The only articles where you can get any coherent information have been written by third parties.
- If you want to preview a native RibbonBar image in an Access form, you can't use the Access image control - you have to use the MS Forms image control, which is not fully supported in Access.
"Without intellisense and without an Object Browser view of the ribbon hierarchy, it's very, very difficult to make headway on ribbon customization."
A correction: The RibbonBar gui does not have an object model, so the hierarchy has to be viewed in some other way.
On 20 Sep I posted my Custom RibbonX Reviewer BETA, for free download. The Reviewer loads a custom RibbonBar into a treeview to show the full hierarchy, and all attributes and values for each item, as well as displaying the actual RibbonBar. There are also extensive reference resources incorporated into the GUI. The next stage in the project is to deploy the app as an add-in that will work inside the users' ACCDB, and provide in-place editing of RibbonBars using a pseudo-object model.
I sent an email to the Access Team Blog on this app, in the hope I would get some support or feedback. The email has been ignored.
Wednesday, September 26, 2007
Microsoft has confirmed that Excel 2007 incorrectly displays the result of a calculation in 12 specific cases where a result should equal around 65,535. The issue is not in the calculation itself but in the result that is shown in the sheet.
For example, =850*77.1 will display an incorrect value, but if you then multiply the result by 2, you will get the correct answer (i.e. if A1 contains “=850*77.1”, and A2 contains “=A1*2”, A2 will return the correct answer of 131,070).
A patch is in the works. More
Friday, September 21, 2007
2007 Office System Document: Digital Signing of Microsoft 2007 Office System Documents The 2007 Microsoft Office system provides many security improvements over its predecessors, including digital document signing. This white paper introduces the reader to digital signatures: what they are and how to use them.
2007 Office System Document: The Microsoft Office Fluent User Interface: Information Worker Perception of Productivity, Training, and Support Requirements This white paper presents the results of a Forrester Research study commissioned by Microsoft to help organizations and individuals understand the benefits of the Fluent user interface and address some of the challenges they may have in transitioning to Microsoft Office 2007.
2007 Office System Document: The Microsoft Office Fluent User Interface: IT Decision-Maker Perception of Productivity, Training, and Support Requirements This white paper presents the results of a Forrester Research study commissioned by Microsoft to help IT organizations considering Microsoft Office 2007 adoptions anticipate the impact of the new Fluent user interface on their end users.
Thursday, September 20, 2007

Click on the image to zoom in...
I am making available a free BETA of my Access 2007 RibbonX Reviewer for download. Make sure you read the readme file.
This is very much a stage 1 app, with the aim being in the next stage to deploy it as an add-in that will work inside the users' ACCDB, and eventually to provide in-place editing of Ribbonbars. I put the BETA out now, so that any bugs can identified before I go too far into the next stage.
Open the file RibbonXReview.accde in Access 2007 to review sample Access 2000 RibbonBars using the USysRibbons table.
Theres are also extensive reference resources incorporated into the GUI.
You can load your own USysRibbons table by importing it into the ACCDE and replacing the sample USysRibbons table.
Tuesday, September 18, 2007
Download Office 2003 Service Pack 3 (SP3). SP3 includes updated security and previously released hotfixes.
Some of the changes in Service Pack 3 modify the behavior of Office 2003, including changes that disable some features by default and increase control for computer administrators. Changes include:
- Office 2003 can no longer open or save certain file formats. For more information, see Microsoft Knowledge Base Article 938810.
- MAPI forms do not run in public folders and user folders. For more information, see Microsoft Knowledge Base Article 938816.
- Office 2003 can now be configured to allow or deny specific COM components. For more information, see Microsoft Knowledge Base Article 938815.
- Some COM components with unusual characteristics may not function as expected. For more information, see Microsoft Knowledge Base Article 938814.
- Changes have been made to the behavior of Microsoft Office Document Imaging. For more information, see Microsoft Knowledge Base Article 938813.
- Attachments with the .gadget extension can no longer be opened in Outlook. For more information, see Microsoft Knowledge Base Article 938811.
- Access add-ins can no longer be configured for use by all users. For more information, see Microsoft Knowledge Base Article 938809.
- The Fast Save setting in Microsoft Office Word has been removed. For more information, see Microsoft Knowledge Base Article 938808.
- Documents saved in certain formats no longer contain the version number of Office. For more information, see Microsoft Knowledge Base Article 938807.
- Certain macros in older Excel file formats have increased security. For more information, see Microsoft Knowledge Base Article 938806.
Known issues after you install Office 2003 SP3:
- After you install a Microsoft Office service pack, you are prompted unexpectedly to restart the computer. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 905726 (http://support.microsoft.com/kb/905726/) You are unexpectedly prompted to restart the computer after you install an Office service pack or an Office update
- After you install Office 2003 SP3, an add-in, ActiveX control, or COM add-in may not work as expected in an Office 2003 program. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938814 (http://support.microsoft.com/kb/938814/) The functionality of an add-in, an ActiveX control, or a COM add-in is reduced, or the functionality is blocked after you install Office 2003 Service Pack 3
- After you install Office 2003 SP3, you may receive an error message when you try to create a new MAPI form in Outlook 2003. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938816 (http://support.microsoft.com/kb/938816/) Error message when you try to create a new MAPI form in Outlook 2003: "contact the administrator"
- After you install Office 2003 SP3, attachments that contain the .gadget extension cannot be opened in Outlook 2003. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938811 (http://support.microsoft.com/kb/938811/) Attachments that contain the .gadget extension cannot be opened in Outlook 2003 after you install Office 2003 Service Pack 3
- After you install Office 2003 SP3, the Fast Saves feature does not work as expected in Word 2003. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938808 (http://support.microsoft.com/kb/938808/) The Fast Saves feature in Word 2003 no longer functions after you install Office 2003 Service Pack 3
- After you install Office 2003 SP3, the Microsoft Office Document Imaging program may not work as expected. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938813 (http://support.microsoft.com/kb/938813/) You may experience issues when you run the Microsoft Office Document Imaging program after you install Office 2003 Service Pack 3
- After you install Office 2003 SP3, you may receive an error message when you try to open or to save a file. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 941636 (http://support.microsoft.com/kb/941636/) You receive an error message when you try to open a file or to save a file after you install Office 2003 Service Pack 3
- After you install Office 2003 SP3, you cannot open some Microsoft Excel workbooks that contain Microsoft Visual Basic for Applications (VBA) macros. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938806 (http://support.microsoft.com/kb/938806/) You cannot open Microsoft Excel 5.0/95 Workbook files that contain Visual Basic for Applications macros in Excel 2003 after you install Office 2003 Service Pack 3
- After you install Office 2003 SP3, the version number of Office is no longer saved in the properties of the document as expected. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938807 (http://support.microsoft.com/kb/938807/) Office files that are saved in certain formats no longer contain the version number of Office after you install Office 2003 Service Pack 3
Office 2003 SP3, promising improved security and enhanced compatibility with Windows Vista, Office 2007, Internet Explorer 7 and Windows SharePoint Services, will be available tomorrow (September 18, 2007). Source
Tuesday, September 11, 2007
Excel 2007 Download: Excel 2007 XLL Software Development Kit The Microsoft Office Excel XLL Software Development Kit (SDK) contains conceptual overviews, programming tasks, and sample projects to guide you in developing Excel 2007 XLLs.
Friday, September 07, 2007
The Microsoft Visual Studio 2005 Tools for Office Second Edition (VSTO 2005 SE) redistributable package (build 8.0.50272.891) (x86) installs the Visual Studio Tools for Office runtime, which is required to run solutions built using VSTO 2005 or VSTO 2005 SE.
Friday, August 31, 2007
Office Hotfix Installer is designed to help administrators deploy update files within their organizations, by reading a series of deployment instructions contained in an INI file, and then using those instructions to apply an update to a computer. Office HotFix can also check applications on a computer to determine which updates need to be applied, and it can order a group of update files so that an installation is optimized.
XML Schema Designer - August 2007 CTP This first Community Technology Preview of the XML Schema Designer is a graphical tool for working with XML Schemas. This CTP introduces XML Schema Explorer - a tool that helps you navigate, search and work with schema sets, and automatically apears when you open or create an xsd file in Visual Studio. It is docked with the Solution Explorer tool.
Prerequisite: Download and install Visual Studio 2008 Beta 2. Microsoft .NET Framework 3.5 Beta 2 is included in the installation.
Thursday, August 30, 2007
Create a Windows Installer Package for an Office 2007 Solution
Deploying Visual Studio 2005 Tools for Office 2007 Solutions Using Windows Installer Learn how to deploy a Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System (also known as Visual Studio 2005 Tools for Office Second Edition, or VSTO 2005 SE) solution using a Visual Studio 2005 Setup project to create a Windows Installer package.
Wednesday, August 29, 2007
From TechRepublic.Com blogger, Susan Harkins.
Exporting Outlook folders and their contents is a common and simple enough task most of the time using the Import And Export Wizard. But you can’t append records to an existing file using the Wizard. If you want to export frequently to the same database, or if you just want to take the process out of user hands, use VBA to automate the export. Article and Code
For today only from Giveaway of The Day, a free licensed copy of the fully featured code editor Multi-Edit Lite 2006. Supports VB, VBA, VB.NET, ASP, ASP.NEt, and more. Download
Tuesday, August 28, 2007
Integrating Access Contacts with SharePoint and Outlook
The Access Team Blog has posted VBA code on using the new Add From Outlook feature in Access 2007 to work on a custom contacts table. This feature uses the same mechanism to determine that a table is a contact table, but more than that it needs to know how to map fields in your table to those in the Outlook contact store. This code will take any table, and make it into a contacts table. You just add the code to your solution, then update the table name and field names to reflect the fields in your custom contacts implementation, and run it.
Thursday, August 23, 2007
This download from Microsoft allows you to export and save Office 2007 documents to the PDF and XPS formats. It also allows you to send email attachments in the PDF and XPS formats in a subset of Office 2007 programs.
You can now also copy and distribute the object code form of the add-in together and for use only with the Microsoft Office Access 2007 Runtime software, subject to the license terms accompanying the Microsoft Office Access 2007 Runtime software download.
These are very useful resources:
Access Freak Access 2007 Tutorials
AccessRibbon.com
Ribbon Customizer
Thanks to robcooper of the Access Team Blog and Oli-S for these links.
Wednesday, August 22, 2007
Rob Cooper of the Access Team Blog, has posted a tip on creating item templates for Access 2007 Ribbon customizations.
The Microsoft Office SharePoint Server 2007 SDK contains conceptual overviews, “How Do I…?” programming tasks, developer tools, code samples, references, and an Enterprise Content Management (ECM) starter kit to guide you in developing solutions based on Microsoft Office SharePoint Server 2007.
Tuesday, August 21, 2007
Office 2007 Sample: Building Server-Side Document Generation Solutions Using the Open XML Object Model
This download from Microsoft provides sample files in Microsoft Visual Basic.NET and Microsoft C# that show how to use the Open XML object model to assemble documents from a server-side application, and accompanies the following MSDN articles:
SQL Server Migration Assistant (SSMA) is a free suite of tools from Microsoft to reduce the effort, cost, and risk of migrating from Oracle to SQL Server. SSMA is said to automate almost every aspect of the migration process including assessment, schema and data migration, business logic conversion, and validation. Companies such as Motorola and Simon & Schuster have used SSMA to migrate their business-critical databases.
Monday, August 20, 2007
A new video demo on using the Access 2007 Navigation Pane has been published on the Office On-Line portal.
You can also access these articles from the portal:
- Use the Navigation Pane to quickly view and access objects
- Create and manage custom categories and groups in the Navigation Pane
Friday, August 17, 2007
Ezy Documenter Premium Edition New v6.1
Add-In for Microsoft© Access 97 - 2007

Standard Edition featured in Woody's Access Watch
Ezy Documenter Premium automatically documents and prints in fully formatted Access reports all the objects in your Access database: tables and fields, table relations, query definitions, forms and record sources, reports and record sources, code modules, macros, data access pages, references, custom command bars, and database properties. Users can customize of each Ezy Documenter Database Report.
New in v 6.0:
- Linked table paths
- Data Access Pages: name, linked URL, and Data Source
- Custom Command Bars
- All Database Object Properties
New in v 6.1:
- Updated GUI
- Users can now select the export folder
Only US$39.95 including free upgrades to new versions.
Thursday, August 16, 2007
The MSDN Community Distribution CD Image Download for August 2007 is now available for download (693mb)
Wednesday, August 15, 2007
From Bink.nu:
Microsoft Office 2007 SP1 Technical Preview Available If you were a member of the Microsoft Office Product Evaluation TAP, you should now have access to the Microsoft Office 2007 System Service Pack 1 Technical Preview. Just log into Connect, and check under Microsoft Office. This is going to be a short one preview. Microsoft is only accepting feedback for about 30 days, so start downloading now!
Monday, August 13, 2007
Exploring a desktop Access 2007 database
Create an Access 2007 database using templates
Build forms in Access 2007 using design tools
Thursday, August 09, 2007
The new Access 2007 database engine, which reads and writes .accdb files, is available as a redistributable EXE file (25mb) for those developers who need to code against the file directly, by-passing Access/VBA.
The download installs a set of components that can be used by non-Microsoft Office applications to read data from 2007 Office system files such as Microsoft Office Access 2007 (mdb and accdb) files and Microsoft Office Excel 2007 (xls, xlsx, and xlsb) files. Connectivity to Microsoft Windows SharePoint Services and Text files is also supported.
ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.
Courtesy of KBAlertz.com:
Access 2000
935370 Issues that you may encounter when you open or are using a Microsoft Office Access database on a computer that is running Windows Vista
934526 Description of the security update for Office 2000: May 8, 2007
Access 2002
932857 You may receive an error message when you try to install or run an Office program: "This patch package could not be opened" or "The installation source for the product is not available"927680 Error message when you try to create a database from a Visual SourceSafe project in Access 2003 or in Access 2002: "Failed to import file"
927680 Error message when you try to create a database from a Visual SourceSafe project in Access 2003 or in Access 2002: "Failed to import file"
Access 2003
934151 Description of the Office 2003 post-Service Pack 2 hotfix package for Office 2003 Proofing Tools: March 12, 2007934182 Description of the Office 2003 post-Service Pack 2 hotfix package for the Italian thesaurus and for the Italian MUI: March 9, 2007
932844 Description of the Office 2003 post-Service Pack 2 hotfix package: February 12, 2007
932848 Description of the Office 2003 post-Service Pack 2 hotfix package for the Office 2003 proofing tools: February 21, 2007
932841 Description of the Office 2003 post-Service Pack 2 hotfix package for the Italian MUI and for the Italian proofing tools: February 21, 2007
932840 Description of the Office 2003 post-Service Pack 2 hotfix package for the Italian thesaurus, for the Italian MUI, and for Office 2003 Proofing Tools: March 6, 2007
933734 Description of the Office 2003 post-Service Pack 2 hotfix package for the Italian version of Office 2003: March 1, 2007
934180 Description of the security update for Office 2003: May 8, 2007
936748 Issues that are fixed in Access 2003 by Office 2003 Service Pack 1
Office 2003: Overview of Developer Technologies A white paper that presents an overview of developer technologies and tools to help enable solution developers to build custom solutions for Microsoft Office 2003 Editions.
Office 2007: Developer Posters Download these posters to learn more about the new features of and enhancements to the 2007 Microsoft Office System.
Tuesday, August 07, 2007
SQL Server Magazine Events
Upcoming Web Seminar
Get the Most from DFS This web seminar on August 14, 2007 will cover what DFS is and how it works, the server and client OS versions that support DFS, how to configure DFS, the limitations of DFS, using DFS-N and DFS-R, as well as managing DFS. We will explain the basics of DFS and provide a quick "how-to" on implementing DFS-N and DFS-R in your Windows Server 2003 environment.
On-Demand Web Seminars
High Performance Connectivity for SQL Server 2005 and SSIS Learn how best-of-breed high-speed data interconnects to the new SSIS environment make plug-and-play with mainframe, legacy, Teradata, and other database systems a reality. These new connectors are drop-in solutions that are cost-effective, and provide best-of-breed bi-directional data movement.
Keep Exchange Running - The High Availability Imperative If there is a "killer app", it's email. Business communications rely heavily on email, and an increasingly mobile base of users and clients continually lowers the tolerance for email downtime. Attend this informative eSeminar sponsored by CA XOsoft, and hear from Paul Robichaux, who will share helpful information that can help you meet your enterprise's HA needs. Register now so you won't miss out on this chance to learn how to keep your Exchange servers running — and what to do if disaster strikes.
Keep Unsecured Machines Off Your Network Tune into the hottest up-to-date network security protection through this exclusive podcast featuring Windows IT Pro editor Karen Forster and Microsoft’s Ian Hameroff. Learn how Network Access Control (NAC) and Network Access Protection (NAP) work and what technologies are involved, as well as what third-party products are poised to work with these technologies.
Monday, August 06, 2007
The MS Access Team Blog at Microsoft has posted a timely article explaining how the new format Access 2007 database ADDT template files work, and there is a tip on how you can create your own template with a button click! More
I would also add that by renaming an ADDT to a ZIP, you can unzip any template into a folder hierarchy of the component objects, and you can then review/edit the individual XML documents .
Friday, August 03, 2007
Codeplex is the project hosting site for Microsoft SQL Server Samples and Community Projects. The portal catalogs samples included with Product Releases, samples from the community, and independent SQL Server Community projects.
You can also download samples databases. The Product samples are the latest Microsoft samples released with Service Packs or major releases of SQL Server. Community samples are sample code and applications from Microsoft, MVPs, and the SQL Server community at large. There are release notes and brief descriptions of all the sample databases and code.
Monday, July 30, 2007
The Office Lecture site offers a range of free MS Office tutorials. There is also an affiliate site Free Programming Books with a range of free downloadable eBooks. Both are ad-driven portals, but definitely worth browsing.
Wednesday, July 25, 2007
Before Access 2007, you could calculate totals on your data in an Access query, report, or form. Now Access 2007 lets you add a Total row field to your tables. Article from Mary Ann Richardson ot TechRepublic.com.
Tuesday, July 24, 2007
- 2007 Microsoft Office System Document Encryption
- Migrating to the 2007 Microsoft Office System
- How to Use Information Rights Management in the 2007 Microsoft Office System
- Office Communicator Web Access (2007 release) Planning and Deployment Guide
- Office Communications Server 2007 Release Notes
- Office Communications Server 2007 Command-Line Reference Guide
- Office Communications Server 2007 Technical Overview
- Office Communications Server 2007 Standard Edition Deployment Guide
- Office Communications Server 2007 Enterprise Edition Deployment Guide
- Office Communications Server 2007 Active Directory Guide
- Office Communications Server 2007 Archiving and CDR Server Deployment Guide
- Office Communicator 2007 Quick Reference Card
- Office Communicator 2007 What's New Guide
- Office Communicator 2007 Quick Reference Card for Keyboard Shortcuts
- Office Communicator 2007 Quick Reference Card for Phone and Video
- Office Communicator 2007 Quick Reference Card for Phone and Video
- Office Communicator 2007 Frequently Asked Questions
- Office Communicator 2007 Group Policies
- Office Communicator 2007 Getting Started Guide
Monday, July 23, 2007

I have just discovered this cool new IT-focused portal: ITSearchEngine
Saturday, July 21, 2007
Access 2007 Runtime Re-Issued
You can also download the Access 2007 Developer Extensions package.
Tuesday, July 17, 2007
FIX: The Cluster Discrimination tab is empty when you browse a clustering
model of SQL Server 2005 Analysis Services in SQL Server BIDS
FIX: You cannot cancel an MDX query that runs for a long time in SQL Server
2005 Analysis Services
FIX: A server may start slowly if you have SQL Server 2005 Analysis Services
installed and if many objects are stored on the server
Monday, July 16, 2007

An interesting review of the ZOHO On-Line Office-Style Applications Suite.
This article from TechRepublic.com shows you how to use the the Styles section of the Home tab in the Excel 2007 Ribbon.
Excel Services is a new way to interact with Excel spreadsheets, allowing you to add spreadsheets and workbooks to your enterprise dashboards and portals on Office SharePoint Server 2007. This free sample chapter from the Microsoft Press book, Programming Excel Services, covers:
- Understanding Excel Services and Microsoft Office SharePoint Server 2007
- Understanding the History of SharePoint
- Installing and Configuring Excel Services
Thursday, July 12, 2007
Migrating from Oracle: When SQL Server 2005 Makes Sense From DevX.com An article that rounds up a few ways to make longstanding Oracle adherents feel not only comfortable but highly conversant with SQL Server.
Tuesday, July 10, 2007
FIX: You may experience poor performance after you install SQL Server 2005 Service Pack 1
FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '
Office Security Updates for July 2007
Security Update for the 2007 Microsoft Office System (KB936514) A security vulnerability exists in the 2007 Microsoft Office System and the Compatibility Pack for the 2007 Office System that could allow remote code execution. This update resolves that vulnerability.
Security Update for Excel Viewer 2003 (KB936508) A security vulnerability exists in Microsoft Office Excel Viewer 2003 that could allow arbitrary code to run when opening a malicious document. This update addresses that vulnerability.
Security Update for Excel 2002 (KB936513) A security vulnerability exists in Microsoft Excel 2002 that could allow remote code execution. This update resolves that vulnerability.
Security Update for Excel 2000 (KB936511) A security vulnerability exists in Microsoft Excel 2000 that could allow remote code execution. This update resolves that vulnerability.
Security Update for Microsoft Office Excel 2007 (KB936509) A security vulnerability exists in Microsoft Office Excel 2007 that could allow remote code execution. This update resolves that vulnerability.
Saturday, July 07, 2007
As more users deploy Access 2007 on Windows Vista desktops, Access developers can expect a quantum leap in support calls. I have found that simple VBA code that works in all 32-bit versions of Access, including Access 2007 on pre-Vista Windows, does not work in Access 2007 on Vista.
Service packs are required now!
Tuesday, July 03, 2007
SQL Server 2005 Best Practices Analyzer (July 2007) The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings, using a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.
Saturday, June 30, 2007
I just bought my-self a new PC and a 19in wide-screen monitor. While the actual screen area is 94% of my old standard 19in LCD, the Office VBA window for all versions after Office 97, is now more user-friendly, with the sidebar object browser sitting nicely at the side of the screen, with no loss of characters in the code panel.
In Access 2007, the new Database Window sidebar comes into its own, and also provides a natural border where you can adjust the actual width of a form as you work on it, while the shorter screen enforces a more disciplined form design.
Wednesday, June 27, 2007
Perhaps it may be wiser to be a tortoise rather than a hare for downloads like this...
From the What's New In Access 2007 Blog:
Wednesday, June 27, 2007 10:57 AM Access Runtime is on Hold. It turns out that there was a recall class issue with one of the Access Runtime components. After we released the Access Runtime yesterday it was discovered that patches on Microsoft Update would not automatically detect and patch this component. We unfortunately had to pull down the Access Runtime download until we can ensure that all components are supportable.
We are sorry for the inconvenience, and we are aiming to have it back up in a couple of weeks. If you happen to be one of the few to download the Access Runtime, please wait for the new, supportable version before deploying to your customers.
Tuesday, June 26, 2007
From the What's New in Access 2007 Blog:
For those of you who have been struggling a little with Ribbon customization in Access 2007 and miss the old world of CommandBars where you could design the command experience directly through the UI, Patrick Schmid has a cool add-in that allows you to make graphical design changes to your Ribbons from right within Office. It works with all Office apps that have the Ribbon.
His tool is free to try, and he's also currently got a beta program going. You can pick up the trial here: http://pschmid.net/office2007/ribboncustomizer/download.php, and join the Beta here: http://pschmid.net/office2007/ribboncustomizer/betaprogram.php.
Access 2007 Developer Extensions and Runtime are LIVE and FREE!
Access 2007 Download: Access Developer Extensions
Access 2007 Download: Access Runtime PS: This download pulled by MS on 27 June 2007 - see Access Extra Post 27 June 2007
Thursday, June 21, 2007
You need an MS Live ID to access this content:
- Changing the Appearance of Documents Using Microsoft® Office Word 2003
- What's New in Microsoft® Office Professional Enterprise Edition 2003
- What's New: Microsoft® Windows® 2000 Professional to Windows XP Professional
- Introduction to the New Microsoft® Office Fluent™ User Interface
- Getting Started with Windows Vista
- Getting Started with Microsoft Office Word 2007
- Getting Started with Microsoft® Office Excel® 2007
- Getting Started with Microsoft Office PowerPoint 2007
- Getting Started with Microsoft® Office Outlook® 2007
- Creating a New Database Using Microsoft® Office Access 2003 Finding and Organizing E-Mail Messages
- Using Microsoft® Office Outlook® 2003
- Getting Started with Microsoft® Small Business Accounting
- Making Presentations Look Consistent Using Microsoft® Office PowerPoint® 2003
- Managing Business Contacts and Payroll Data with Microsoft® Small Business Accounting
- Managing Cash Flow with Microsoft® Small Business Accounting
- Managing Customer and Vendor Data with Microsoft® Small Business Accounting
- Performing Calculations on Data Using Microsoft® Office Excel 2003
- Reporting and Administering with Microsoft® Small Business Accounting
- Working with Files and Folders Using Microsoft Windows® XP Professional Service Pack 2
Access 2007: Get Up to Speed
- Three self-paced lessons and three practice sessions for hands-on experience. Practices require Access 2007.
- A short test at the end of each lesson; tests are not scored.
- A Quick Reference Card you can take away from the course.
- Download a database from the new Getting Started page.
- Create database objects by using the new Ribbon.
- Save and share your data in appropriate formats.
FIX: An access violation may occur in SQL Server 2000 Analysis Services when you try to use a 2007 Office system program to open an offline local cube
Restore a SQL Server database to a new server If you have to move databases to a new server, you have two options for carrying out this task: SQL Server Management Studio (GUI) or T-SQL (Command line). This download from TechRepublic.com shows you both methods.
Tuesday, June 19, 2007
Using the Business Data Catalog and Smart Tags with the 2007 Office System
2007 Office Sample: Using the Business Data Catalog and Smart Tags with the 2007 Office System This code sample accompanies the MSDN article, Using the Business Data Catalog and Smart Tags with the 2007 Office System, available from the Related Resources section of this download page.
Monday, June 18, 2007
Microsoft has announced that after June 30, 2007, OEM Office 2003 will no longer be available from Microsoft. Some authorized OEM distributors may have some remaining inventory left for a short time after June 30th; however,Microsoft will no longer be shipping OEM Office 2003 to them. More
Iterating through tables and databases in SQL Server This tip from TechRepublic.com presents two very handy stored procedures that live in the master database but are not mentioned in SQL Server Books Online.
Friday, June 15, 2007
Solution Accelerator for Office 2007 Business Desktop Deployment
Solution Accelerator for Business Desktop Deployment Download planning, building, and technical guidance, templates, and scripts to facilitate deployment of Windows Vista and Office 2007
Version: 1.1
Published by Microsoft on: June 7, 2007
Download Size: 27.7 MB - 55.4 MB
The Solution Accelerator for Business Desktop Deployment (BDD) is best-practice guidance for desktop deployment, targeted at companies that want to reduce deployment time, effort, and cost by increasing the level of automation. BDD allows administrators to deploy desktops with Zero Touch and Lite Touch interaction at the target PCs, and also helps organizations move to a managed environment with standardized desktop images.
BDD 2007 is offered in two versions to support Solution Accelerator component installation on x64 or x86 hosts. You select the version that corresponds with your host hardware type: both versions support x86 and x64 client operating systems.
Wednesday, June 13, 2007
Hotfix Rollup for the 2007 Microsoft Office System (KB935520) Microsoft has released an update for the spelling checker in the 2007 Microsoft Office programs. This release is an update to the English-language dictionary.
Take Parts of the MSDN Library Offline with PackageThis!
Created by the MSDN development team, PackageThis! allows you to choose documentation sets from the MSDN Library to save as HXS or CHM format files. You simply select nodes in the MSDN Library tree view to package as your own local mini-library, or to build into your own library. Multiple languages are supported. Cool!
FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed in a database mirroring session in SQL Server 2005.
FIX: An access violation may occur when you try to log in to an instance of SQL Server 2000.
Friday, June 08, 2007
SQL Server 2005 Books Online (May 2007) Download an updated version of the documentation and tutorials for Microsoft SQL Server 2005.
Tuesday, June 05, 2007
Product Focus: SmartForm ADP
When you work with Access Data Projects (ADPs), the native Access form wizard - even in Access 2007 - is very basic:
With my SmartFormADP Form Wizard, you can easily build a smart elegant auto-filter form based on any SQL Server table or view in a matter of seconds using only mouse-clicks:
SmarfFormADP for ADPs/ACCDPs comes bundled with SmartForm+ for MDBs/ACCDBs and is available for immediate download for only US$29.95.
Monday, June 04, 2007
New Office 2007 Downloads
2007 Office System: Microsoft SDK for Open XML Formats Technology Preview This download provides strongly typed part classes for use with Open XML documents.
Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists This add-in works with Excel 2007 to allow you to synchronize data in a table with a list on a SharePoint site.
Wednesday, May 30, 2007
This article from TechRepublic.com explores the benefits and side effects of using three types of table hints when running queries in SQL Server: READCOMMITTED, REPEATABLEREAD, and SERIALIZABLE. The previous article in this series covered NOLOCK and READPAST.
Other SQL Server articles from Tech Republic:
- Experiencing the power of SQL templates
- Building a data values dictionary with SQL
- Using recursion in stored procedures
- Develop more quickly by re-using databases
- Recovering from hardware upgrade problems with SQL
- Create a histograph in SQL Server
Sunday, May 20, 2007
Access Junkie, Jeff Conrad, Access MVP Alumni and a Microsoft Software Engineer on the Excel - Access Services Team, has established a very useful site devoted to Access 2007 and its new features and technologies. There is a broad range of resources and links available. The best Access 2007 site I have visited.
Jeff has also co-authored Microsoft Office Access 2007 Inside Out (MS Press)
Tuesday, May 15, 2007
The Microsoft Office Access 2007 Developer Reference Portal provides conceptual overviews, programming tasks, samples, and references to guide you in developing Access solutions.
The reference has the following sections:
- What's New New members by object and in alphabetical order.
- How Do I... in Access 2007 A map of how-to topics of custom Access solutions.
- Concepts Important concepts for developing custom Access solutions.
- Access Object Model Reference
- Access Macro Actions Documentation for all of theAccess macro actions .
- Microsoft Data Access Objects (DAO) Reference
- Microsoft ActiveX Data Objects (ADO)
- Microsoft Jet Replication Objects (JRO)
- Microsoft Access SQL Reference
- Microsoft Access Database Engine Error Reference
Monday, May 14, 2007
Download a free sample chapter from VBA for the 2007 Microsoft Office System (Que) exploring variables and how to use them in your VBA procedures.
Chapter topics include:
- Declaring variables
- Avoiding variable errors
- Understanding variable data types
- Using array variables
- Working with constants
- Storing user input in a variable
Friday, May 11, 2007
How to run a SQL Server 2005 Integration Services package as a SQL Server Agent Job
FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005
FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053
Tuesday, May 08, 2007
A new feature in Access 2007 is on-the-fly filtering of forms.
My Ezy Filter Plus Access Add-In, which has been around for a while, provides more advanced on-the fly filtering for forms and reports, and for Access 97 to Access 2003 as well:
- Easily filter any existing data form or previewed report in any Access database
- An add code options allows developers to add Ezy Filter to their applications.
1. Invoke the Ezy Filter Plus Add-In and click Add Code to add Ezy Filtering to your database:
2. In any Access form or report click the Ezy Filter button on the form view toolbar or popup menu and start filtering:
3. Click the Filter toggle button to return to the unfiltered form:
Buy Ezy Filter Plus now and get the Ezy Reporter Add-In for free - a 50% saving.
Workgroup security has been dropped from Access 2007, which I personally see as a big negative.
In many Access applications users can create new objects at runtime, such as queries, forms and reports. A compiled MDE/ACCDE will not cut it as you can't protect your developer objects and code, and allow users to create their own objects. In prior versions of Access 2007, you could selectively protect developer objects and give users permissions to create new objects, using the very robust Access workgroup security features. This means that many of my Access application and add-ins will not be distributed in the Access 2007 format. One wonders if the Microsoft Access development team considers the views of developers and users.
Having said this, MSDN has just published an article by MVP and fellow-Aussie, Garry Robinson, Security Considerations and Guidance for Access 2007, which is the first comprehensive discussion of security in Access 2007.
Gary has also written a valuable book on pre-Access 2007 security: Real World Microsoft Access Database Protection and Security.