Microsoft KB Archive/169276: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 53: | Line 53: | ||
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<br /> | 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<br /> | ||
<pre class="fixed_text"> Set rstTmp = conPubs.OpenRecordset( | <pre class="fixed_text"> Set rstTmp = conPubs.OpenRecordset("Authors",dbOpenDynamic,, | ||
dbOptimistic) | dbOptimistic) | ||
</pre> | </pre> | ||
Line 61: | Line 61: | ||
<div class="errormessage"> | <div class="errormessage"> | ||
Run-time Error | Run-time Error "3027:<br /> | ||
Can't update. Database or object is read-only. | Can't update. Database or object is read-only. | ||
Line 75: | Line 75: | ||
[[../164481|164481]] ACC97: Tips for Converting Applications to Using ODBCDirect<br /> | [[../164481|164481]] ACC97: Tips for Converting Applications to Using ODBCDirect<br /> | ||
<br /> | <br /> | ||
For more information about using the OpenRecordset method with ODBCDirect, search the Help Index for | For more information about using the OpenRecordset method with ODBCDirect, search the Help Index for "ODBCDirect workspaces," and then "Use ODBCDirect with Microsoft Access." | ||
</div> | </div> |
Latest revision as of 11:06, 21 July 2020
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:
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