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.
Wednesday, December 27, 2006
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
Saturday, December 16, 2006
Thursday, December 14, 2006
MSDN Articles on Using Visual Tools for Office 2007
- Creating Custom Task Panes Using Visual Studio Tools for Office
Learn how to create custom task panes with Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System.
- Customize the Office (2007) Ribbon UI for Developers (Part 1)
Learn how new features in Visual Studio 2005 Tools for the 2007 Microsoft Office System support RAD development of Ribbon customizations.
- Customize the Office (2007) Ribbon UI for Developers (Part 2)
Find detailed reference material about the controls and method signatures of the Ribbon user interface.
- Customize the Office (2007) Ribbon UI for Developers (Part 3)
Get a list of frequently asked questions regarding the Ribbon user interface.
- Migrate a Document-Level Customization to an Application-Level Add-In
Learn how to migrate your document-based solutions to application-level add-ins.
- Migrating a Shared Add-in to a Visual Studio Tools for Office Add-In
Learn about issues you might have with migrating existing shared add-ins.
- Migrating a VBA Solution to a Visual Studio Tools for Office Add-In
Add new functionality to your VBA solution using the VBA skills you already have and Visual Studio 2005 Tools for Office.
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.
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.
When ACC is first opened, it will detect which supported versions of Access are installed on your PC.
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 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.
- 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 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
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
Subscribe to:
Posts (Atom)