Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/169276

From BetaArchive Wiki
Knowledge Base


ACC97: OpenRecordset Method Options Incorrect for ODBCDirect

Article ID: 169276

Article Last Modified on 1/19/2007



APPLIES TO

  • Microsoft Access 97 Standard Edition



This article was previously published under Q169276

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:

164481 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 kbprogramming KB169276