Error Opening table: Microsoft Access Database Engine: System resource exceeded

[KMadamba]

Hi experts,

I have been trying to run a workflow that performs updating of rows using a multi row field. This is gathering an input file (.xlsb) from a local drive with a size of 51 mb (having about 500k rows) and it has been giving me this error: Error Opening Table: Microsoft Access Database Engine: System resource exceeded.\3035 = -66192371

I have already upgraded my laptop to 8gb ram as I have noticed that Alteryx shoots up my RAM consumption  to 71%.. I reckon that I should still have about 30% free, but I am still getting this error.

Has anyone else encountered this error? And if so, what can be done to resolve it?

Appreciate any help given. Thank you

[DanM]

@KMadamba,

This error is definitely coming from your Access Database. Are you using the supported Access driver?  Are you using a 2010 Microsoft Access Database Engine?

Drivers:

DataSources

Here is also a related post 

[KMadamba]

@DanM I have already installed the 2010 driver when I got an Access engine error before. This one seems to be different.

 It looks like changing the join/sort memory allocation back to default fixed it though, as I am not getting the error anymore.

cheers

Edit: Nevermind. Still getting the error. It's intermittent :-\

[DanM · Accepted solution]

@KMadamba ,

If the issue is intermittent, then it may be something with the your machine or the Access database. If you are adjusting the sort/join memory and that is temporarily resolving the issue, it is more than likely you may be running out of memory. If you close all programs and just run the process in Alteryx do you get the error? I would keep your process monitoring up and see if you memory spikes when you get the error.