Wednesday, January 21, 2009

ADP Developers: Stick With SQL Server 2005

The MS Access Team Blog has today posted this advice:
  • Access 2007 ADP’s will run against SQL Server 2008 but do not support designing server objects (tables, views, stored procedures, functions and relationships).

  • SQL Server 2008 shipped after Office 2007 SP1 and after MS had locked down all the fixes for Office 2007 SP2 (coming out in a few months).

  • If you rely on the design features of ADP’s it is recommended that you stick with SQL Server 2005.

  • If you do make the move to SQL Server 2008 use the SQL Server Management Studio to design your server objects.

Monday, January 19, 2009

Free Bug Tracking Access 2007 Database Application available for download

This new the template is available in the Access Getting Started screen in the business category and on Office Online. These on-line videos will help you get started:

New Access 2007 Demo:
Bring your business data together in an Access database

The Microsoft Office On-line portal today issued for download a new sample Access 2007 database dashboard application which integrates business contact data with an address book, lists of orders, file folders, and ledgers. View the associated article on Office Online.

New Version of Access 2007 Developer Extensions

The Jan09 version of the Access 2007 Access Developer Extensions package is available for download.

The Access 2007 Developer Extensions provide packaging and deployment tools and licensing and distribution agreements for deploying Access 2007 applications. The Access Developer Extensions include the following components:
  • Package Solution Wizard A wizard that creates a Windows Installer Package (MSI) to install your database and any supporting files and optionally includes the Access 2007 Runtime, or prompts the user to download the Access 2007 Runtime.
  • Save As Template Enables you to create database templates (ACCDTs) that can be featured in the Access 2007 Getting Started screen.
  • Source Code Control Integration with Microsoft Visual SourceSafe or other source code control systems to allow check-in/check-out of queries, forms, reports, macros, modules, and data. You can also see the differences that have been made to your checked out objects.
The Access 2007 Developer Extensions do not include the Property Scanner and the Custom Startup Wizard that were included in previous versions.

The Access 2007 Runtime is also available as a download.