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.