Accessing huge Microsoft Access DB

[wschwarz]

Hi,

I am using the standard MS-Access Node to for a MS-Access-DB. This database is quite huge (approx. 2GByte). When executing this node, it get’s not finished. Any hints how to deal with big MS-Access-databases?

Thanks

Werner

[izaychik63]

I would use

Microsoft Access Connector — NodePit

and

DB Query Reader — NodePit

[ipazin]

Hi there @wschwarz,

welcome to KNIME Community!

If I got you right you have problem establishing connection with database, haven’t you? If that is the case database size doesn’t play a role in it as far as I understand the process. (And 2 GBs is not huge for database in my opinion).

Is there anything specific about this database? You can also check your log file. Maybe there is more info. From within KNIME go View--> Open KNIME log. Prior to that you can set you log level to DEBUG. From within KNIME go File --> Preferences --> KNIME.

Br,
Ivan

[mlauber71]

@wschwarz

I am using the standard MS-Access Node to for a MS-Access-DB. This database is quite huge (approx. 2GByte).

I experienced problems with 2 GB MS Access databases. When they reached a certain volume they just stopped responding or do anything at all. No warning nothing. That seems to stem from the time of 32 Bit systems but still is in force today.

And keep in mind the DB would also need some room for temporary operations and stuff.

The only workaround was to split the database into several files (which is not very elegant). So it might not be a problem related to KNIME.

Access specifications - Microsoft Support

Is there a file size limit to Microsoft Access?

[ipazin]

Oooo
So it is size related…