Accessing huge Microsoft Access DB

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

I would use


and

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

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.

https://www.quora.com/Is-there-a-file-size-limit-to-Microsoft-Access

2 Likes

Oooo :eyes:
So it is size related…

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.