@Brock_Tibert can you tell us more about the error message and your system setup especially the RAM. Maybe even a log file in debug mode.
MS Access is not an ideal data storage and has limitations of what it can hold. I would not recommend using it other than pure necessity.
I have this article about how to handle large datasets with knime.
If you want very large local DB files you can use H2 which can create chunks. SQLite might be another option since it can hold very large datasets.