Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: Macro Actions Is Replaced with Comments in Design View

ACC2000: Macro Actions Is Replaced with Comments in Design View

View products that this article applies to.

This article was previously published under Q280373
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

↑ Back to the top

Symptoms

When you open a Microsoft Access 2000 macro in a Design view, you notice that certain actions have been replaced with comments.

↑ Back to the top

Cause

Access 2002 has new macro actions that are not available in Access 2000. Macro actions that are new in Access 2002 do not appear in Design view of a macro in Access 2000. Instead, the new actions appear as comments in Access 2000.

↑ Back to the top

Resolution

To see the macro actions, open the file in Microsoft Access 2002.

↑ Back to the top

Status

This behavior is by design.

↑ Back to the top

More information

Because you can use Access 2002 to design objects in Access 2000 file format, it is possible to create a macro that contains macro actions that are only available in Access 2002. When you later open this macro in Access 2000, the new macro action is unavailable, and a comment appears as a placeholder for the Access 2002-specific macro action.

Steps to Reproduce the Behavior

1.In Access 2002, open any Access 2000 database or project.
2.Create a new macro.
3.Enter the following information into this new macro:
   Macro Name Condition  Action
   --------------------------------------
   A1                    MsgBox
   A2                    CopyDatabaseFile

   A1 Action Arguments
   ---------------------------------
   MsgBox
   Message: Getting ready to copy...
   Beep: Yes
   Type: None
   Title: Copy File

   A2 Action Arguments
   ---------------------------------------------
   CopyDatabaseFile
   Database File Name: C:\My Documents\My DB.mdb
   Overwrite Existing File: Yes
   Disconnect All Users: No
4.Save the macro as Macro1, close the macro, and then close the database or project.
5.In Access 2000, reopen the same database or project.
6.Open the Macro1 macro in Design view. Note that the action for A1 (MsgBox) is still available. However, the action for A2 is blank, and there is a comment to indicate that an Access 2002-specific action (CopyDatabaseFile) is not available to Access 2000 users.

↑ Back to the top

Keywords: KB280373, kbprb

↑ Back to the top

Article Info
Article ID : 280373
Revision : 2
Created on : 7/13/2004
Published on : 7/13/2004
Exists online : False
Views : 248