finding librett*

ljdoncel,

Thank you *AGAIN* SO MUCH.

You're most welcome!

Thanks a lot to both of you for these tips!!

I have worked with MS Access for ages. Its main constraint is that accdb files cannot be larger than 2 Gb (but I have tables with 10+ million rows).

So far I have found workarounds with the tsv file size, but themselves will come to an end (because of these ever increasing damned episodes...)

Any hint for a open/free DBMS I could plug to my Access "Front office" with good performances?
I have spent too much time developping forms, controls, VBA/SQL, etc. to start all over again!!

Anyway, thanks again for the tips above :)

Hi, @Vincent :

In the hospital where I work we had the same problem a few years ago. Since 2000 we began to use (and sometimes still do) Microsoft Access to produce all our patient reports, including admissions, complementary tests, appointments, etc. When the database reached the then Office 2003 1 GB limit, we had to extract some of the larger tables into another mdb file and link them to the original file. In fact, recently we exceeded the current Office 2017 2 GB limit (combining all database files) and we are still employing it without any problem. So, short answer: try linking rather than embedding.

Hi @ljdoncel,

I am already using external Access accdb/mdb, especially for IMDb tsv files, but even so, upload would fail for the larger ones, e.g. title.principals data is already 1,7 Gb big, which does not leave room for indexes.

I am using a workaround by uploading only filtered rows through an external joint. But this is only temporary and therefore I am investigating about alternative DBMS with ODBC with Access (but I am still no IT guru !)