Results 1 to 2 of 2
  1. #1
    Jamesb is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2016
    Posts
    2

    Append Query causing Access to crash

    I have an append query that appends data from a table that updates emails form the outlook inbox (InboxT) into another table (EmailMasterT) which all of a sudden causes Access 2016 to crash when I run it.



    INSERT INTO EmailMasterT ( Dated, Person, Subject, Message, Attachment, Title )
    SELECT InboxT.Received, InboxT.From, InboxT.[Normalized Subject], InboxT.Contents, InboxT.[Has Attachments], InboxT.Priority
    FROM InboxT
    WHERE (((InboxT.Priority) Is Null));



    I have a similar query that does the same for Sent Items that still works fine and it appends to the same EmailMasterT table.

    INSERT INTO EmailMasterT ( Dated, Person, Subject, Message, Attachment, Title )
    SELECT SentItemsT.Sent, SentItemsT.To, SentItemsT.[Normalized Subject], SentItemsT.Contents, SentItemsT.[Has Attachments], SentItemsT.Priority
    FROM SentItemsT
    WHERE (((SentItemsT.Priority) Is Null));

    I have tried recreating it with no positive result.

    Any ideas for a solution would be appreciated.

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    It may be a data-related issue. One of the records that you are trying to append may be corrupted and/or trying to add characters that don't belong in Access. How many records are there, can you look thru them manually? Try adding some manually and see if that is ok by using copy and paste.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access crash
    By JennyL in forum Access
    Replies: 6
    Last Post: 01-19-2017, 03:42 AM
  2. Access can't append all the records in the append query
    By fluffyvampirekitten in forum Access
    Replies: 2
    Last Post: 08-27-2015, 01:53 AM
  3. Replies: 0
    Last Post: 11-20-2014, 01:37 PM
  4. Access crash
    By Tjaaaa in forum Access
    Replies: 10
    Last Post: 03-07-2014, 05:41 PM
  5. Query SQL Crash
    By Scorpio11 in forum Queries
    Replies: 1
    Last Post: 07-20-2010, 02:32 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums