Access 2007 Runtime SP1 Now Available

Access 2007 Runtime SP1 is now available for download.

The Runtime SP1 contains files versions later than the files updated by Office 2007 Service Pack 1 (SP1). Get additional information from the Access Team Blog.

Implement Custom Paging with SQL Server 2005

The default behavior of .NET data components involves retrieving the entire results of a query when loading data for display on a page. A better approach involves loading only data that will display on the page. In this article Tony Patton of TechRepublic.com shows you how to use ListView and GridView controls to implement custom paging with a SQL Server 2005 backend.

Microsoft Business Desktop Deployment Kits

Business Desktop Deployment 2007 provides planning, building, and technical guidance, templates, and scripts to facilitate deployment of Windows Vista® and the 2007 Microsoft® Office system. This release includes updates to support Windows Vista SP1 in addition to previously supported platforms.

Microsoft Deployment Toolkit 2008 is the next version of Business Desktop Deployment (BDD) 2007. It is the recommended process and toolset to automate desktop and server deployment. This release includes updates to support Windows Vista SP1 and Windows Server 2008 in addition to previously supported platforms.

SQL Server Resources and Links

Official SQL Server Resources:

• SQL Server 2005 Elearning Portal Nine FREE Microsoft E-Learning courses for Database Administrators, Database Developers, and Business Intelligence Developers.
• Microsoft SQL Server
• MSDN SQL Server Developer Center
• Microsoft SQL Server TechCenter
• SQL Server Support Center

SQL Server Community Resources:

• Professional Association for SQL Server (PASS)
• SQL Junkies

SQL Server 2005 Webcast Live and on Demand:

• Webcasts and Chats for SQL Server
  
• TechNet Support WebCast: Overview and deployment of Microsoft SQL Server 2005

Latest SQL Server Fixes

FIX: The %TEMP% folder is not cleaned up after you use database mail to send an e-mail message that has an attachment in SQL Server 2005

FIX: Error message when you use a symmetric key to decrypt data in a SQL Server 2005 database: "The decryption key is incorrect"

Access and the Web: Integrating with Office Live Small Business

A fascinating article has been posted on the Access Team blog, on a SIMPLE and seamless way to bring Access 2007 databases to the web, using the free Office Live Services portal: Pushing Access Data to the Web: Integrating with Office Live Small Business

Latest Access Knowledge Base Articles

Courtesy of KBAlertz.com:

Access 2000

• 913178 Description of the Jet 4.0 Database Engine post-837001 hotfix package: February 17, 2006
• 943509 Description of the Jet 4.0 Database Engine hotfix package for Windows XP SP2, for Windows Server 2003 SP1, for Windows Server 2003 SP2, and for Windows Vista: October 23, 2007

Access 2003

• 938792 Issues that are fixed in Office 2003 by Office 2003 Service Pack 3
• 923618 Description of Office 2003 Service Pack 3
• 943967 After you install Office 2003 SP3, you encounter various problems in an Access project when you work with a Bit data type column in a linked SQL Server table.
• 943509 Description of the Jet 4.0 Database Engine hotfix package for Windows XP SP2, for Windows Server 2003 SP1, for Windows Server 2003 SP2, and for Windows Vista: October 23, 2007.
• 945674 Description of the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007.

Access 2007

• 946621 Security-related Group Policy settings in the 2007 Office system do not work as expected.
• 938888 Description of the 2007 Office hotfix package: June 17, 2007.
• 924739 Error message when you try to add an existing Windows SharePoint Services list to an Access 2007 database: "You do not have the necessary permissions to use the '. Describes a problem that occurs when you try to add an existing SharePoint list that contains a column name that has more than 64 characters to an Access 2007 database. Provides a workaround.
• 937999 Error message when you run a macro that calls a VBA function in an Access 2007 database: "Action Failed Error Number: 2950". Discusses a problem that occurs after you use the ADE 2007 Package Solution wizard to package an Access 2007 database application. After you install the packaged application, a potential security concern message appears when you open the application.
• 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.
• 895456 How to change the product key for Office 2003 and for Office XP.
• 932994 You receive an error message when you run a query that includes a field name that begins with a double-byte Arabic number in Access 2007 or Access 2003.
• 937998 The Access 2007 Developer Extensions command is missing from the Microsoft Office Button in Access 2007 .
• 936748 Issues that are fixed in Access 2003 by Office 2003 Service Pack 1. Discusses a problem in which you receive error messages when you use wizards and Visual Basic for Applications commands in Access 2003 on a Windows-Vista based computer when the computer has both Access 2003 and Access 2007 installed.
• 938809 Error message when you try to install an Access 2003 add-in for all users by using the Add-In Manager on a Windows Vista-based computer: "There was an error adding to the registry" .
• 924460 How to manage templates in 2007 Office programs. Describes the different template categories and the locations of templates in 2007 Office programs. Also describes the registry settings that control where to find your custom templates.

Download SQL Server Compact

SQL Server Compact 3.5 Books Online and Samples SQL Server Compact 3.5 is a small footprint in-process database engine that allows developers to build robust applications for Windows Desktops and Mobile Devices.

Try SQL Server 2008

Try SQL Server 2008 Free for 180 Days Download the latest SQL Server 2008 Community Technology Preview and try out the latest features.

SQL Server 2008 Feature Pack Community Technology Preview - February 2008 Download the February 2008 Feature Pack Community Technology Preview - a collection of stand-alone install packages that provide additional value for SQL Server 2008.

SQL Data Services: Cloud Obscures Visibility

Microsoft has launched this new BETA product, which I guess you could liken to SQL Server for the Web.

This is how it is described in a post on the Access Team Blog (and I thought it was an Access blog):

Microsoft is now getting into the lightweight database game with SQL Server Data Services. It looks to follow a similar pattern to simpleDB and CouchDB with named, attribute pairs in a flat storage space and accessibility through REST. Some of the interesting things they are bringing to the game:

• Query data using LINQ
• Property support for simple data types (string, numeric, date, boolean)
• Paging management for data retrieval
• Rich client library in C# and VB with LINQ support
• SSL Security

It looks like a great cloud based simple storage system with some of the goodness MSSQL bring to the table. They are now signing up BETA testers and we will be putting some demos together to show how Access can work with these lightweight database systems.

Translation please...

Critical MS Office Updates On March 11

In a security bulletin yesterday Microsoft announced it will issue four critical patches for Office on March 11 for:

• Excel 2000
  
  
• Outlook 2000, 2002, 2003 and 2007
  
  
• Remote code execution vulnerabilities in Microsoft Office 2000 (SP3)
  
  
• Web components for Office 2000

NEW V4.0 of Ezy Exporter Premium Edition
Add-In for Microsoft© Access

The functionality Microsoft forgot! My Ezy Exporter Premium Edition Access Add-In is the easy way to export unlimited Access objects and data in bulk.

In v4.0 you can now also export relationships, commandbars, import/export specs, and library references.

A best-seller at the Office Marketplace.

NEW NESTED TreeView MS Access Switchboard
for Microsoft© 2000/2002/2003/2007

Fully Nested with Unlimited Levels and Tree Menu Builder Add-In

Screenshot from Access 2000 in Windows XP: click on image to zoom

I have just uploaded my latest Access Switchboard: the NESTED TreeView Demo Database feature cutting-edge application navigation and the unique Nested TreeView Switchboard Builder, which lets you easily build complex windows-explorer like tree menus.

When you purchase the source code MDB, you get as a free bonus the Treeview Switchboard Builder Access Add-In, which allows you to automatically populate the TreeView Switchboard in your Access database with multi-level hierarchical switchboard menus and menu items.

Download the DEMO: