ACC1x: Sample File for Reattaching Tables Programmatically

Article ID: Q114551
Creation Date: 05-MAY-1994
Revision Date: 24-APR-1997

The information in this article applies to:

Microsoft Access versions 1.0, 1.1

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

Microsoft Access version 1.x does not have a built-in method for reattaching a table whose attachment has become invalid. An attachment can become invalid for a variety of reasons, the most of common of which is that the path to the file containing the table has changed.

The sample database REATTACH.MDB, included in the REATTACH.EXE file, demonstrates a method that you can use to check attached tables and reattach them if necessary.

 ~ REATTACH.EXE (size: 29097 bytes) 
                is available for download from the Microsoft Software
   Library. It contains the following files:

   REATTACH.MDB   A sample database that provides the components for
                  reattaching Microsoft Access tables.
   README.TXT     A text file explaining how to use REATTACH.MDB.

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

Additional query words: transferdatabase attach
Keywords : kbfile Softlib
Version : 1.0 1.1
Platform : WINDOWS
Hardware : X86
Issue type : kbinfo

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.