# Microsoft Office Access 2003 Readme File

Microsoft Office Access 2003 Readme File

### © 2003 Microsoft Corporation. All rights reserved.

This document provides late-breaking information about Microsoft Office Access 2003.

### How to use this document

To view the Readme file on the screen, maximize the browser window. To print the Readme file, click the Print button on the toolbar.

## Contents

### Installation issues

Microsoft SQL Server 2000 Desktop Engine Service Pack 3 is included with Access 2003

Updated version of Microsoft Jet 4.0 required to block unsafe expressions

### Converting to Microsoft Office Access 2003

Converting previous-version data access pages

Using Microsoft Office Web Components with Access 2003

Viewing dependency information

##### Security

Wizards are not available if Trust all installed add-ins and templates is disabled

Database digitally signed with a beta version of Access appears to be unsigned

The Dir function is blocked in sandbox mode

### Exporting, importing, and linking to data

Linking to a SharePoint site

### Using smart tags and themes

Adding a smart tag to a table or view in an Access project

Selecting a smart tag from the Smart Tag property builder

Requirements for applying a theme to a form

Theming for forms is turned off in previous-version databases

## Installation issues

### Microsoft SQL Server 2000 Desktop Engine Service Pack 3 is included with Access 2003

You have the right to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), which is located in the \MSDE2000 folder, for use under the terms of the End User License Agreement for this product.

For more information about possible updates to MSDE 2000, go to http://www.microsoft.com/technet/security/current.asp and search for security bulletins associated with MSDE 2000. To search for security bulletins associated with MSDE 2000, in the Product/Technology list box, select SQL Server Desktop Engine (MSDE) 2000. In the Service Pack list box, select SQL Server Desktop Engine (MSDE) 2000 SP3, and click Go.

To install SQL Server 2000 Desktop Engine, double-click the MSDE2KS3.EXE self-extracting program in the \MSDE2000 folder on your Office 2003 or Access 2003 CD. By default, the files will be extracted to the c:\sql2ksp3 folder. You can specify another location, but the following instructions are based on this default location.

You must install MSDE 2000 from the command prompt with command-line options that differ depending on whether you are installing MSDE 2000 for the first time or upgrading an earlier version of MSDE 2000.

New installation

On the Windows Start menu, click Run, type cmd, and then press ENTER. The command prompt appears. Type the following commands:

    cd \sql2ksp3\msde
    setup.exe SAPWD="AStrongSAPwd"

Replace `"AStrongSAPwd"` with your own strong password for the sa logon account.

Upgrading from SQL Server 2000 Desktop Engine to Service Pack 3

On the Windows Start menu, click Run, type cmd, and then press ENTER. The command prompt appears. Type the following commands:

    cd \sql2ksp3\msde
    setup.exe /upgradesp setup\sqlrun01.msi SAPWD="AStrongSAPwd"

Replace `"AStrongSAPwd"` with your own strong password for the sa logon account.

More information

For more information about installing SQL Server 2000 Desktop Engine, see the Sp3readme.htm file in the folder containing the extracted the MSDE 2000 files (c:\sql2ksp3\MSDE by default).

Clean up

When the installation or upgrade is complete, you can delete the c:\sql2ksp3 folder.

### Updated version of Microsoft Jet 4.0 required to block unsafe expressions

To block unsafe expressions in Access 2003, you must download the latest version of Microsoft Jet 4.0 from http://windowsupdate.microsoft.com. Microsoft Jet 4.0 Service Pack 8 (SP8) allows Access 2003 to be fully functional yet still have Jet block unsafe expressions by enabling sandbox mode. If sandbox mode is not enabled and macro security is set to Medium or High, you will see a security warning every time you open a file.

## Converting to Microsoft Office Access 2003

### Converting previous-version data access pages

To convert a data access page that was created using Access 2000, you must have the Microsoft Office 2000 Web Components installed on your computer. The Microsoft Office 2000 Web Components are included with Microsoft Office 2000 and Microsoft Office XP.

A data access page created by using Access 2002 does not need to be converted before it is used with Microsoft Office Access 2003. Access 2003 uses the Microsoft Office XP Web Components, which is the same version as those used in Access 2002.

### Using Microsoft Office Web Components with Access 2003

Access 2003 uses the Office XP Web Components instead of the Office 2003 Web Components. If you created a data access page or an application with Web Components using Access 2003 Beta, you will need to modify the page or the application code to revert to the previous version of the Web Components.

To revert from Office 2003 Web Components to the Office XP Web Components, you need to change the GUIDs of the components to reference the Office XP version in the page or code. The following table lists the GUIDs for both versions of the components.

Component | Office 2003 Web Components GUIDs | Office XP Web Components GUIDs | Comments
--- | --- | --- | ---
MSODSC | CLSID:0002E55B-0000-0000-C000-000000000046 | CLSID:0002E553-0000-0000-C000-000000000046 | B has been changed to 3.
PivotTable list | CLSID:0002E55A-0000-0000-C000-000000000046 | CLSID:0002E552-0000-0000-C000-000000000046 | A has been changed to 2.
Chart | CLSID:0002E55D-0000-0000-C000-000000000046 | CLSID:0002E556-0000-0000-C000-000000000046 | D has been changed to 6.

Note You do not need to change the GUID of the Spreadsheet component.

### Viewing dependency information

In Access 2003, you can view a list of objects that use or are being used by the selected object. This feature helps you understand the design of the database and maintain it. The dependency information is generated by reading the name maps created by the Track name AutoCorrect info feature. Note that the Perform name AutoCorrect feature need not be enabled to view dependency information.

The name maps created in Access 2002 and previous versions do not contain all the information needed to track dependencies accurately. If you open a previous-version database in Access 2003 and attempt to view dependency information, you will be asked whether you want to update the dependency information. Choose to update the name maps if you want to view dependency information.

## Security

### Wizards are not available if "Trust all installed add-ins and templates" is disabled

Wizards in Access 2003 will not run if you set the macro security level to High and disable Trust all installed add-ins and templates.

To view the default settings or to change the macro security settings, on the Tools menu, point to Macro, and then click Security. On the Security Level tab, the default setting is Medium. On the Trusted Publishers tab, the Trust all installed add-ins and templates check box is selected by default. With these default security settings, the wizards will run as expected.

If you change the security level to High and clear the Trust all installed add-ins and templates check box, the wizards will not run.

### Database digitally signed with a beta version of Access appears to be unsigned

When you open a database that was digitally signed in a beta version of Access 2003, there is no indication that the database has been digitally signed and the Visual Basic for Applications (VBA) project is locked.

To correct the problem, reapply the digital signature to the database in Access 2003, close the database, and reopen it.

### The Dir function is blocked in sandbox mode

The Dir function is blocked when the Microsoft Jet Expression Service is configured to run in sandbox mode. The function cannot be used in expressions, but it can be utilized in Visual Basic for Applications (VBA) code.

For more information about the functions that are blocked when Jet is configured to run in sandbox mode, see Access Help.

## Exporting, importing, and linking to data

### Linking to a SharePoint site

Linking to a list with a long name

Access cannot link to a list on a site that is running Microsoft Windows SharePoint Services if the name of the list exceeds 255 characters. Rename the list on the SharePoint site, making sure the name is not longer than 255 characters, and try linking again.

Refreshing and requerying database objects that are linked to lists

When you refresh a form that is bound to a table that is linked to a list on a SharePoint site, Access does not update the form with the latest data from the source. It just repaints the form. To get the latest data, close and reopen the form or use the Requery command.

## Using smart tags and themes

### Adding a smart tag to a table or view in an Access project

The only way you can add a smart tag to a table or view in an Access project is by adding the MS_SmartTags extended property using Transact-SQL. The easiest way to add smart tags in a project is to add them to your forms, reports, and data access pages.

### Selecting a smart tag from the Smart Tag property builder

The Smart Tag property builder does not list all available smart tags. It lists only those whose actions are defined in Access.

### Requirements for applying a theme to a form

In Access 2003, you can apply a theme to a form if the following requirements are met:

- The operating system is Microsoft Windows XP SP1 or Microsoft Windows Server 2003.
- You have enabled theming in Windows by selecting a theme other than the default theme.
- You have enabled theming for forms in the database.

### Theming for forms is turned off in previous-version databases

The option to apply themes is enabled by default in databases that are created by using Access 2003. To enable themes for forms in a database that was created by using Access 2002 or earlier, on the Tools menu, click Options, and on the Forms/Reports tab, select Use Windows Themed Controls on Forms.