Microsoft KB Archive/280373

= ACC2000: Macro Actions Is Replaced with Comments in Design View =

Article ID: 280373

Article Last Modified on 7/13/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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).



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



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.



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



STATUS
This behavior is by design.



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
 In Access 2002, open any Access 2000 database or project. Create a new macro.  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                    Save the macro as Macro1, close the macro, and then close the database or project.</li> In Access 2000, reopen the same database or project.</li> 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.</li></ol>

Additional query words: prb not there gone missing converted

Keywords: kbprb KB280373

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.