ACC97: OpenRecordset Method Options Incorrect for ODBCDirect

 Last reviewed: June 3, 1997
Article ID: Q169276
The information in this article applies to:
  • Microsoft Access 97

SUMMARY

The OpenRecordset Method Help Topic in Microsoft Access 97 states the following for the Options parameter: 

   options  Optional. A combination of constants that specify
            characteristics of the new Recordset, as listed in
            Settings.
However, in an ODBCDirect workspace, you cannot use the Options parameter. You must supply a zero (0) for the argument. If you attempt to create syntax that supplies the option, or you omit the zero, as in the following syntax 

   Set rstTmp = conPubs.OpenRecordset("Authors",dbOpenDynamic,,
   dbOptimistic)
you receive the following error message: 

      Run-time Error "3027:
      Can't update. Database or object is read-only.

REFERENCES

For more information about using ODBCDirect, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q164481
   TITLE     : ACC97: Tips for Converting Applications to Using ODBCDirect
For more information about using the OpenRecordset method with ODBCDirect, search the Help Index for "ODBCDirect workspaces," and then "Use ODBCDirect with Microsoft Access."

Keywords : kbcode kbprg
Version : 97
Platform : WINDOWS
Hardware : x86
Issue type : kbdocerr
Resolution Type : Info_Provided

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" 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.

Last reviewed: June 3, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.