I’m having this issue where access database throws exception saying system resource exceeded and I’m using execute query activity to get the count of records in database table.
Here is the query which I’m using “Select Count(*) from Tablename”. I’m using three different access database files and using the same query for all of the 3 database files at different levels of code. However I get this error for only 1 specific database.
Hi @lakshman, there are about 1.2 lakh records in the file which i’m getting the error. However there is another database file which has nearly 4 million records and the same query is working fine without any issues.