Microsoft KB Archive/90104

{|
 * width="100%"|

PRB: OpenTable Action Ignores Data Mode Setting If Table Open
'Article ID: Q90104

Creation Date: 08-OCT-1992

Revision Date: 30-NOV-1996' The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

In a macro, the OpenTable action ignores a change you make to the Data Mode argument setting if the table is already open. If you open table A in Read Only mode, and then you opened it a second time in edit mode without closing it first, the table will still be in Read Only mode.

CAUSE

If an OpenForm, OpenTable, or OpenQuery action is called, and the window is already open, you will switch to the new view, but the Data Mode argument setting cannot be switched.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

  Create the following macro: Macro Name     Action -     Test1           OpenTable OpenTable Actions -     Table Name:       (Give any existing table name here) View:            Datasheet Data Mode:       Read Only  Save and run the macro. Leave the table open and return to the Database window. Open the Test1 macro in Design view, and change the Data Mode argument to Edit. Save the macro and run it again. Note that when you run the macro a second time with a different Data Mode setting, the Table window is activated but the table is still in Read Only mode. Again, this behavior only occurs if the table is already open when you run the OpenTable action.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

KBCategory: kbusage

KBSubcategory: McrActn

Additional reference words: 1.00 1.10 2.00 7.00 97 8.00