I just ended up keeping MS Access on my application and did away with the view that was giving me problems. When you import a SQL View to MS Access it imports the data as a table and it was too large.

My workaround was to replace in my code where i was calling a View, to a dynamic SQL Statement.