MS Access System Resource Exceeded Error

[Dave Hinkle]

Hi All,

I get the following error after connecting and disconnecting many times to
an Access DB from perl:

DBI->connect(djhtest) failed: [Microsoft][ODBC Microsoft Access Driver]
System resource exceeded. 
(SQL-S1001)(DBD: db_login/SQLConnect err=-1) at F:\TEMP\djh\b.pl line 10

The code is as follows:

use DBI;
use strict;

my $i;

while(1) {
    my $dbh;
    $dbh=DBI->connect("dbi:ODBC:djhtest");
    $dbh->disconnect();

    $i++;
    print "\nCount=$i\n";;
}

The above code is just used to quickly recreate the error, but I will be
doing many connects/disconnects to access DB over time, which fails after a
while.

I'm using ActiveState Perl build 620, DBI 1.14, DBD-ODBC v.28, MDAC v2.5, NT
4.0 SP6.

Any ideas?

Thanks,
Dave