Cannot Add or Delete Records After Performing a Join in Q+E

Last reviewed: October 31, 1994
Article ID: Q46019

SUMMARY

Once two files have been joined with either Select Join or Select Outer Join, adding new records or deleting records is not allowed until the file has been saved and reopened.

This restriction applies because the joined file does not have a disk file to write to. Saving the results of the join to a file and then reopening the file allows the adding and deleting features.

There is no disk file for the window if the title bar of the file lists more than one filename in parentheses after Query#.

KBCategory: kbother
KBSubcategory:
Additional reference words: 2.10

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 31, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.