PRB: Syntax Errors in "Advanced Topics" Sample Functions

Article ID: Q120909
Creation Date: 21-SEP-1994
Revision Date: 13-MAR-1995

The information in this article applies to:

Microsoft Access Developer's Toolkit version 2.0

SYMPTOMS

Pages 36-37 of the Microsoft Access Developer's Toolkit version 2.0 "Advanced Topics" manual contains a sample function called ReattachTables(). The code for the ReattachTables() function contains the following lines:

   On Error GoTo ReattachTables Err
   ReattachTables Err:

The syntax of these lines is incorrect.

RESOLUTION

Change the lines in the ReattachTables() function to be:

   On Error GoTo ReattachTables_Err
   ReattachTables_Err:

MORE INFORMATION

The CheckAttached() and ReattachTables() functions are meant to be run from an extended installation database at the end of a custom Setup program to check and correct attachments in the application database installed by the Setup program. As they are listed in the "Advanced Topics" manual, however, these functions check the attachments in the current database instead of in an external database.

The syntax corrections in this article cause the functions to check and correct attachments in an external database as they were designed to do.

REFERENCES

For more information about extended installation databases, please see the Microsoft Access Developer's Toolkit "Advanced Topics" manual, version 2.0, Chapter 2, "Creating a Custom Setup Program," page 31.

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.