ACC1x: Default Values of Attached Table Not Used

Last reviewed: June 6, 1997
Article ID: Q98669

The information in this article applies to:

Microsoft Access versions 1.0, 1.1

SYMPTOMS

When you attach a table from another Microsoft Access database, the default values in the attached table do not appear.

CAUSE

The default values in attached tables do not appear because Microsoft Access does not read the properties of attached tables.

STATUS

This behavior no longer occurs in Microsoft Access version 2.0.

MORE INFORMATION

Steps to Reproduce Behavior

In any Microsoft Access database, create a new table with a field with a data type of Number, and a default value of 5. Save the table as Table1.
Close the database, and open or create another database.
Attach Table1 to the current database.
Open Table1, and enter a few values. Note that the default value of 5 does not appear.

REFERENCES

Microsoft Access "User's Guide," pages 69-70

Additional query words: external come across
Keywords : IsmIea kbinterop
Version : 1.0 1.1
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : kbfix

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