Hello fellow Database guru's,
I'm using the VB DataControl to handle a large Access 7 database.
The code works fine on smaller databases, but when I attempt to use it on my large database, setting the recordsource to a SQL statement the system generates:
system error &H800040005 (-2147467259).
The error handling routine in the code shows:
Data error event hit err:Out of memory.
Does anyone know what causes this, and how I can get round it?