1 of 1 people found this helpful
If you just created column level filters in Access, that affects only how it's shown in Access and not the semantics of the actual table.
If you create a query in Access, make sure you connect to the query, not the original table.
If you could post your Access file we could probably help you with more details.
Thanks a lot. I think this turned out to be an issue with OneDrive or the client network. To your point, it was connected correctly to the query; it just seems like it was not updating correctly.
Notes for people who might stumble upon this:
- Onedrive did flag itself as fully synced.
- I did refresh the data and the extract and toggle between Live / Extract for good measure.
- I did exit out of the programs (both Tableau and Access, and reopen them).
- I did restart my computer.
- I was NOT able to connect to the client network. I personally don't think any folder paths were set up to have any files or data reliant on that -- it was all cloud-based via OneDrive or locally stored on the local hard drive.
- However, the issue was resolved upon getting back to the client site and being physically on the network.
Will mark this one as solved; appreciate the time.