Share via

Access 2016 linked table randomly loses fields

Anonymous
2023-06-28T19:27:17+00:00

So I'm using Access to create a linked table to an Outlook folder so that I can then pull my Outlook information to excel. I know this is pretty convoluted, but the network I'm on doesn't allow me to link excel to outlook and I don't really know much about Access so I just use it as a middle man.

Issue & Background:

The issue is that every so often (sometime between 1-3 weeks) my Access file stops importing the information I need from Outlook. When I first create the linked table, I get 15-20 columns of data including "Contents" and "Received" which are the two bits of information I need. Then 1-3 weeks later, without me ever opening the access file, most of these columns disappear. I will be left with only 3-4 columns: "Importance", "Icon", "Priority", and/or "Subject".

The only interaction I have with the Access file is when my excel macro runs the command "Connections.OLEDBConnection.Refresh" to refresh the query that pulls the Access table into excel. This command works as intended and I don't think it has anything to do with the issue but I thought I'd mention it.

What I've tried:

Deleting linked table and creating a new link to the same outlook folder.

When I try this I get the same table as before I deleted it (i.e. the table is still missing columns). This makes me think there's an Outlook issue but I'm not sure what it could be.

Creating a new Outlook folder/renaming the old Outlook folder

Both of these require me to update the Access to pull from the new folder name, but this also solves the problem (though temporarily).

Any ideas on how to fix my columns from disappearing? I'm also running Outlook and Excel 2016 if that's pertinent.

Thank you!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-07-05T14:13:19+00:00

    Hi Mia,

    Thanks for taking the time to respond, I'll be sure to post this over there!

    Best,

    Collin

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-07-01T05:18:46+00:00

    Dear Collin Dunton,

    Good day!! Thanks for posting your concern in this Microsoft community.

    Per the description shared, I understand your concern but since it's related to Access 2016, we suggest you to post your concern in the Questions - Microsoft Q&A with Office IT pro tag to get the detaile dhelp from the experts.

    In addition, I will keep this thread open so that Access MVPs and experts in this community to share their ideas and experience on your situation.

    Thanks for your patience and understanding.

    Sincerely,

    Mia | Microsoft Moderator

    Was this answer helpful?

    0 comments