XL7: SQL PassThrough Example in Help Has Incorrect Example

ID: Q140702

7.00 WINDOWS kbprb kbdocerr

The information in this article applies to:

Microsoft Excel for Windows 95, version 7.0

SUMMARY

In Data Access Object (DAO) Reference Help, the "Using SQL PassThrough with DAO" topic contains an incorrect code example under the "To create and execute an SQL pass through query from code" heading.

MORE INFORMATION

The incorrect code example reads:

   Set dbs = OpenDatabase("Salary.mdb" _
        dbs.Connect = "ODBC;dsn=Accounting;uid=Dagny;"& _
        pwd=Bandit;database=Payroll;"
   dbs.Execute "Update UPDATE Employees SET Salary = Salary * 1.1;", _
        dbSQLPassThrough

The correct syntax for this example is shown below:

   Set dbs = OpenDatabase("Salary.mdb")
   dbs.Connect = "ODBC;dsn=Accounting;uid=Dagny;" & _
        "pwd=Bandit;database=Payroll;"
   dbs.Execute "UPDATE Employees SET Salary = Salary * 1.1;", _
        dbSQLPassThrough

REFERENCES

For more information about Using SQL PassThrough With DAO, choose the Index tab in Help and type:

   sql, pass-through queries

KBCategory: kbprb kbdocerr KBSubcategory:

Additional reference words: 7.00

Version           : 7.00
Platform          : WINDOWS

Last Reviewed: March 29, 1997