PRB: "Argument Not Optional" Error Using DAO 3.5

Last reviewed: October 16, 1997
Article ID: Q168206

The information in this article applies to:

Microsoft Visual Basic Professional and Enterprise Editions for Windows, versions 4.0, 5.0

SYMPTOMS

After porting a Visual Basic 4.0 program that is written using DAO 3.0 (Data Access Objects) to DAO 3.5, the error message:

   "Argument Not Optional"

will occur on the Update, Movelast, and CommitTrans methods. This does not happen in Visual Basic 5.0.

CAUSE

In DAO 3.0, the methods listed above do not use optional arguments. They do use optional arguments in DAO 3.5. This is a problem caused by adding the Typed Optional Parameter feature to OLE Automation. Only newer Automation controllers such as Visual Basic 5.0 are going to understand this. Visual Basic 4.0 can accept optional parameters only if they are of the Variant data type. The optional arguments for the methods listed above are not Variant so it doesn't recognize them as optional.

RESOLUTION

There are three options for this problem:

Do not use DAO 3.5 with Visual Basic 4.0. Use DAO 3.0 or lower.
Use the optional arguments listed in the DAO 3.5 Help file.
NOTE: The Help file states that the optional argument constant for Movelast is dbRunAsync. This is not true and it will not work. The actual argument is rdAsyncEnable.
Do not use early binding on the recordset object. For example, the following code will cause the error:
```
      Dim myrecordset as recordset
```
```
      Set myrecordset = mydatabase("Table1",dbOpenDynaset)
      myrecordset.Edit
      myrecordset.Update
```
Removing the Dim statement will cause it to work as expected.

STATUS

This behavior is by design. Microsoft does not support the use of DAO 3.5 in Visual Basic 4.0. It is recommended that DAO 3.0 or lower be used.

MORE INFORMATION

For information on how to use the methods mentioned above, refer to the Visual Basic online help.

Keywords          : APrgDataAcc VB4WIN vb5all VBKBDAO kberrmsg kbprb
Technology        : kbole
Version           : 4.0 5.0
Platform          : WINDOWS
Issue type        : kbprb

================================================================================

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: October 16, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.