Wednesday, December 27, 2006

Office 2007 Video: Creating Data Portals

2007 Office System Video: Portals Download this series of developer-oriented videos to view conference breakout sessions about customizing search capabilities, building custom portal interfaces, providing personalized views, and aggregating connections to line-of-business data.

Thursday, December 21, 2006

Ezy SQL: Still Only US$19.95

Ezy SQL Editor and Builder Add-In and Wizard for Microsoft© Access 97 - 2007

As used by many enterprise developers, including Lockheed and Kansas Department of Agriculture.

  • Font Name and Font Size Customization
  • Full Find and Replace and Undo functionality
  • SQL Keywords Assistant
  • Parameter Wizard
  • SQL String Parser/Formatter
  • Easy insertion of table and field references
  • Automatically insert formatted SQL Strings into modules or copy to the Clipboard
  • Preview queries, including action queries
  • Automated query versioning
  • Integrated with Access CommandBars and PopUp Menus
  • Also accessible from the Access Query Windows and the VBA Editor

Try the demo

Saturday, December 16, 2006

MSDN Articles for Access 2007 Developers

Creating Managed Add-ins for Access 2007

Ribbon Extensibility in Access 2007

Transitioning Your Existing Access Applications to Access 2007

Thursday, December 14, 2006

MSDN Articles on Using Visual Tools for Office 2007

Just Released: Visual Studio Tools for Office 2007 Add-On for Visual Studio 2005

Visual Studio 2005 Tools for the 2007 Microsoft Office system is now available! Download this fully-supported add-on to Visual Studio 2005 which enables developers to build robust, scalable, line-of-business applications targeting the 2007 Office system.

Download Office 2007 Data Connectivity Componenents

2007 Office System Driver: Data Connectivity Components This download will install a set of components that can be used by non-Microsoft Office applications to read data from 2007 Microsoft Office system files.

Tuesday, December 12, 2006

Office 2007 and Web 2.0 Integration

2007 Office System Document: Bringing Web 2.0 to the Enterprise with the 2007 Office System  This MS white paper explores how the 2007 Microsoft Office system allows enterprises to adopt Web 2.0 ideas and technologies to create high-value, user-driven applications for the Internet and intranet.

Tool for Checking Update Status of Office Installations

Office Update Inventory Tool Version 2.2  The Office Update Inventory Tool version 2.2 enables administrators to check one or more computers in their organization for the status of Microsoft Office 2000, Office XP, Office 2203, and Office 2007 updates.

Wednesday, December 06, 2006

Migrating To Access 2007

Now that Office 2007 has been relased to production, the following are essential resources to guide developers in moving to the new version of Access:

Access 2003 Conversion Tool  You can use the Access 2003 Conversion Tool to analyze databases for upgrade and conversion to Access 2007, by scoping and identifying known issues that have an impact on the conversion process.

Migration considerations for Access 2007  With Access 2007, you can open and use databases created in Access 2000, Access 2002, and Access 2003.  You can also convert databases created with previous versions of Access into the new Access 2007 file format, and create MDE's.  Databases created with Access 97 or earlier must be enabled or converted for use with Access 2007. This TechNet articles discusses database migration considerations, including:

  • Migration considerations for Access 2000, Access 2002, and Access 2003
  • Migration considerations for Access 97 and earlier
  • Access 2007 in mixed environments
  • Access 2007 and SQL Server
  • Tools to help with your conversion project

Access 2007 Specifications

Microsoft has released the Access 2007 specifications:

General

Attribute

Maximum

Access database (.accdb) file size

2 gigabytes, minus the space needed for system objects

Number of objects in a database

32,768

Number of modules (including forms and reports that have the HasModule property set to True)

1,000

Number of characters in an object name

64

Number of characters in a password

20

Number of characters in a user name or group name

20

Number of concurrent users

255

Table

Attribute

Maximum

Number of characters in a table name

64

Number of characters in a field name

64

Number of fields in a table

255

Number of open tables

2048; the actual number might be smaller because of tables opened internally by Access

Table size

2 gigabyte minus the space needed for the system objects

Number of characters in a Text field

255

Number of characters in a Memo field

65,535 when entering data through the user interface; 2 gigabytes of character storage when entering data programmatically

Size of an OLE Object field

1 gigabyte

Number of indexes in a table

32

Number of fields in an index

10

Number of characters in a validation message

255

Number of characters in a validation rule

2,048

Number of characters in a table or field description

255

Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes

4,000

Number of characters in a field property setting

255

Query

Attribute

Maximum

Number of enforced relationships

32 per table, minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships*

Number of tables in a query

32*

Number of joins in a query

16*

Number of fields in a recordset

255

Recordset size

1 gigabyte

Sort limit

255 characters in one or more fields

Number of levels of nested queries

50*

Number of characters in a cell in the query design grid

1,024

Number of characters for a parameter in a parameter query

255

Number of AND operators in a WHERE or HAVING clause

99*

Number of characters in an SQL statement

Approximately 64,000*

*Maximum values might be lower if the query includes multivalued lookup fields.

Form and Report

Attribute

Maximum

Number of characters in a label

2,048

Number of characters in a text box

65,535

Form or report width

22 in. (55.87 cm)

Section height

22 in. (55.87 cm)

Height of all sections plus section headers (in Design view)

200 in. (508 cm)

Number of levels of nested forms or reports

7

Number of fields or expressions that you can sort or group on in a report

10

Number of headers and footers in a report

1 report header/footer; 1 page header/footer; 10 group headers/footers

Number of printed pages in a report

65,536

Number of controls and sections that you can add over the lifetime of the form or report

754

Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp)

32,750

Macro

Attribute

Maximum

Number of actions in a macro

999

Number of characters in a condition

255

Number of characters in a comment

255

Number of characters in an action argument

255

Project specifications

The following list of tables is specific to Office Access 2007 projects:

General

Attribute

Maximum

Number of objects in an Access project (.adp)

32,768

Number of modules (including forms and reports that have the HasModule property set to True)

1,000

Number of characters in an object name

64

Number of columns in a table

250 (Microsoft SQL Server 6.5)

1024 (Microsoft SQL Server 7.0, 2000 and 2005)

Microsoft SQL Server database

Microsoft SQL Server maximum capacity specifications are described in the SQL Server documentation.

Form and report

Attribute

Maximum

Number of characters in a label

2,048

Number of characters in a text box

65,535

Form or report width

22 in. (55.87 cm)

Section height

22 in. (55.87 cm)

Height of all sections plus section headers (in Design view)

200 in. (508 cm)

Number of levels of nested forms or reports

7

Number of fields or expressions that you can sort or group on in a report

10

Number of headers and footers in a report

1 report header/footer; 1 page header/footer; 10 group headers/footers

Number of printed pages in a report

65,536

Number of controls and sections you can add over the lifetime of the form or report

754

Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp)

32,750

Macro

Attribute

Maximum

Number of actions in a macro

999

Number of characters in a condition

255

Number of characters in a comment

255

Number of characters in an action argument

255

Monday, December 04, 2006

Access Control Center Now Free!

A new version of Access Control Center to cover Access 2007 is under development, and I have decided to make the popular current version free. Was US$30.

Download from aadconsulting.com

More info on this fully-featured application follows. Don't pay upwards of US$120 for other applications.

What is Access Control Center (ACC)?

ACC manages all your Microsoft Access database projects from within an integrated project environment.

ACC detects which supported versions of Access are installed on your PC, allowing you to organize projects by Access versions. Projects are managed centrally and .mdb's are opened by the appropriate Access version automatically. Each .mdb has it's own Notes record. The Shortcut Wizard creates desktop shortcuts for secured and unsecured databases. You can compact, repair, and decompile files from within ACC.

System Requirements

ACC requires at least MS Office 97 Professional and VB6 Runtime files.

ACC automatically supports Access 97, Access 2000, Access 2002, and Access 2003 ('supported versions'). You can manually add references to Access 2 and Access.

Setting Up ACC

When ACC is first opened, it will detect which supported versions of Access are installed on your PC.  

Using ACC

The ACC Find Database Wizard automatically locates all Access files in a location and adds them to ACC classified by the Access version required to open a file.

For each Access version installed on your PC, you can also manually add a reference to each database you wish to automatically open with that version. The Add Databases dialog will list all the Access database files in the selected folder, and you can optionally add files in bulk. You can check that a file is compatible with the current Access version by selecting a file and clicking the Check command button. The Check command will attempt to open the file in the current Access version. Duplicate database names are allowed.

Once a database has been added to ACC, you can optionally assign a reference to an Access workgroup file for that database.

The paths of the database file and any assigned workgroup file will be displayed in the first status bar at the bottom of the ACC application window. Double-clicking on a database will open it in the assigned Access version. The second status bar details the size of and date of the file.

You can open supported versions of Access from within ACC by selecting the Access version from the dropdown menu on the Toolbar. Double-click on an Access version node in the ACC data tree to open that version of Access without opening a database.

You can drag a database node from one Access version to another in the ACC data tree by holding down the right mouse button and dragging the database onto another Access version.

Open a database on the fly with command-line options by using the Command-Line Dialog.

After adding a database to ACC, you can also create Windows Desktop shortcuts to the database. You can incorporate command line switches in shortcuts for unsecured databases and also user-specific shortcuts for secured databases. You can also optionally add a shortcut to your Windows Favorites folder for unsecured databases. You can edit a shortcut and add multiple switches.  You can in-text edit all the components of the shortcut, and test the shortcut before creating it.

The Task Pane

The main ACC application window organizes databases by Access version. The main ACC application window organizes databases by Access version. The Task Pane allows shortcuts to any file to be organized by task or project. You can add shortcuts and tasks in the Task Pane, from the ACC application Menubar, or by dragging files from Windows Explorer onto an Access version in ACC or a Task in the Task Pane.

The Task Pane is an integrated floating Task Window, which can be hidden and sent to the icon tray, and with a Stay On Top option. You can add Tasks (ie. Projects, Jobs etc), and add Shortcuts to databases under each Task. The Task Pane is a separate application that, as needed, works in tandem with ACC, and there is an option to turn autostart of the Task Pane off.

Other Features Include:

  • Export the note for a database to a .txt file.
  • Right-click on a database node to Compact/Repair or Decompile a database on the fly.
  • In-place editing of database names within the ACC data tree. The Copy Database Dialog allows in-line editing of the field name.
  • You can toggle between a vertical and horizontal split for the Tree and Notes panes, or hide the Notes pane completely.
  • Drag files from Windows Explorer and automatically create shortcuts by dropping onto an Access version in ACC or a task in the Task Pane.
  • Refresh the date tree by selecting View, Refresh Tree from the Menubar.
  • You can copy a database file to another drive/folder, and re-name a database file from within ACC.
  • Intelligent file dialogs, which default to the most recent database folder used by a selected Access version, or to the folder for the current database file, according to the context, allow easy access to current projects.
  • User settings are saved between sessions.
  • The File Properties Utility allows viewing of database file information from within ACC.
  • Use the Filing Assistant for the bulk copying of files from within ACC.
  • The Logged Users Tool allows you to locate all users and network stations logged into a production Access database, and send network broadcasts to logged-in machines within ACC.
  • Functionality for Access2/95/97 is customized to deal with such issues as .ini files, short file names, and different command-line switches.
  • Extensive Browse File Dialogs assist in the creation of shortcuts and the location of files.

Download from aadconsulting.com


Access Control Center v2.8.2
©2003-2006 Anthony D'Ambra
www.aadconsulting.com

Manipulating Office 2007 Open XML Format Files

2007 Office System Sample: Manipulating Office Open XML Format Files  Download this set of sample files for use with the MSDN article How to: Manipulating Office Open XML Format Documents for Developers.

New SQL Server Resources

From TechRepublic.com:

Understand the effects of NULLs on inner and outer JOINs  This SQL Server tip explains the effects of NULLs, and the different results obtained by inner and outer JOINs.

Turn XML into relational data with OPENXML  XML support has been significantly extended for SQL Server 2005. This article takes a look at how you can shred XML data into a relational format with SQL Server's OPENXML function.

Software download: SQL Visualizer  SQL Visualizer is a Windows client-based SQL Server database query and management tool designed to make SQL development simpler and more productive. Free to try.

Open XML Developer Portal

open XML developer

Open XML Developer  For Open XML Format news and information, a place to get your questions answered and share your insights as well. It's all free, and open to everyone.

Access 2007 and Sharepoint Integration

Microsoft Access 2007

Access 2007 and Windows SharePoint Services 3.0  This TechNet article provides an overview of the changes that Access 2007 introduces over previous versions and takes a look at the new layout and the way the contents of the Ribbon bar in Access changes depending on the context of your work.  Learn how to extend the data gathering reach of Access by including InfoPath email forms and how to extend the reach of the Access database by linking it into WSS.

Sunday, December 03, 2006

New Access 2007 Versions of aadconsulting.com Add-Ins

Access 2007 versions have been added to the following premium product downloads from aadconsulting.com:

  • Access Object Dependency Browser
  • Ezy Documenter
  • Ezy Exporter Premium
  • Ezy SQL
  • SmartForm ADP
  • SmartForm Plus