Not enough storage is available to complete this operation -2147024882

[ReneRud]

I'm trying to read a large table in a large access file (220MB) and I'm getting this error: "Not enough storage is available to complete this operation -2147024882"

I works with smaller access files.

Does anyone have a sollution for this problem?

[daveTW]

Which node throws the error? Run your VI in highlighted mode to see,where the error occurrs.

Maybe the RecordCount number is too high, so perhaps it helps, to read the records in smaller chunks?

[ReneRud]

Thanks for the reply Dave.

The error accurs in "getrows", the table has 3038045 rows.

[daveTW]

Then perhaps this article helps: http://support.microsoft.com/kb/129856/en-us

I found it typing "access recordset getrows" into google search.

[Yamaeda]

i didnt think access could handle 3 million rows.

[dkfire]

Do you really need all the rows at the same time?

Maybe it is better to divide the number of rows your are getting into smaller segments.

[ReneRud]

yes I could do that,

just wanted to know if I could get all the rows at one time