Win10-Client: MS-ACCESS 2010 (32-Bit), ODBC-Driver: 12.01
Linux-Server (1): PostgreSQL 12.2
Linux-Server (2): PostgreSQL 9.6
We are currently migrating form PG 9.6. to 12.x.
We’ve created System-DSNs (PostgreSQL Unicode) with [Defaults] for both Server.
In MS-ACCESS our biggest Server-Tables (>14.000.000 Rows) can be opened (on both Servers).
But it takes a lot of time and uses a lot of memory - more than 450MB.
The indexes are recognized an filtering is fast.
Trying to open more than one “big table” will result in MS-ACCESS “Out of memory”.
Best regards
-Stefan Wolf-