By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,635 Members | 2,227 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,635 IT Pros & Developers. It's quick & easy.

Cannot open any more tables

P: n/a
Can anyone give me some pointers please on where to look next in
solving the problem I'm getting with running a Perl program (my first
of any real complexity) from the command line in WindowsXP?

Basically the program updates from a flat file an Access 2002 database
consisting of just 4 tables (no queries, forms or reports as yet). It
worked fine with a small amount of test data but gave the following
error message after processing 60 or so records from a larger data
file:

DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver]
Cannot open any more tables. (SQL-HY001)(DBD: st_execute/SQLExecute
err=-1) at MyStatistics.pm line 276.

I find the message confusing as the database only has 4 tables and I'm
the only user. Does Access create hidden tables on the fly and is it
these to which the error message is referring? If so, is this a design
or a programming problem? (The design is very straight-forward with the
tables on a single daisy-chain of relationships.)

I've searched various groups but found nothing that seemed relevant.

Any help would be greatly appreciated...

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.