ACC97: One Linked Table Opened Read-Only Makes All Read-OnlyLast reviewed: November 11, 1997Article ID: Q172160 |
The information in this article applies to:
SYMPTOMSModerate: Requires basic macro, coding, and interoperability skills. When you open a linked table as read-only with the OpenRecordset method in code, all linked tables in that database are read-only until the recordset is closed.
RESOLUTIONYou can either open linked tables read-write instead of read-only, or you can create a global recordset variable and run the following code when the database opens:
Dim rsGlobal As Recordset Function InitializeLinkTables() Dim mydb As Database Set mydb = CurrentDb Set rsGlobal = mydb.OpenRecordset("select * from Shippers") End Function STATUSMicrosoft has confirmed this to be a problem in Microsoft Access 97. This problem no longer occurs in Microsoft Jet Database Engine version 3.51, which is available from the Microsoft Software Library. For information on how to obtain Microsoft Jet Database Engine 3.51, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q172733 TITLE : ACC97: Updated Version of Microsoft Jet 3.5 Available on MSL MORE INFORMATIONWhen you open a recordset against a linked table, Microsoft Access caches a Table object with the properties of the first linked table you specify. When you open additional linked tables, they are opened with the cached information. If the first linked table is opened as read-only, all additional linked tables opened are opened as read-only.
Steps to Reproduce ProblemNOTE: There may be other steps that exhibit this behavior. The following steps outline just one known way of duplicating this problem.
Keywords : MdlDao kbprg Version : WINDOWS:97 Platform : WINDOWS Hardware : x86 Issue type : kbbug kbhowto |
================================================================================
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |