473,387 Members | 1,899 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Cannot open any more tables

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
0 3697

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: RdR | last post by:
Hi, I am using Q Replication, I need to set to logging to capture changes on a table but the table has more than 18 characters for the name, I looked at the docs, it mentioned that table names...
4
by: Koen | last post by:
Hi all, At work I created a database which is really helpful. The database is used by approx 15 users. Everything worked great, until I added some 'scoreboard' forms and reports. I get the...
3
by: Glenn Davy | last post by:
Q. How can I 'see' the number of table id's access is using for tracking recordsets? Details: I have some ado code that itterates through a recordset and calls a procedure on each record. This...
2
by: dskillingstad | last post by:
I would really appreciate someone's help on this, or at least point me in the right direction.... I'm working on a permit database that contains 12 tables, and rather than list all of the...
0
by: Smriti Dev | last post by:
Hi, I am creating a tab form that has some subforms within it as aswell. When I sometimes use the forms, I get a 'cannot open more tables error' I would appreciate your help with this. How can...
7
by: Brian Kitt | last post by:
I frequently get the above error on my website. It happens only for short periods of times, then the error goes away. I cannot recreate this. I have an error trap that picks up this error. When...
7
by: Mathew Butler | last post by:
I'm investigating an issue I have when pulling data back from MS access I'm retrieving all rows from a column in a table of 5000 rows - accessing a column of type "memo" ( can be 65353 character...
3
by: epearce301 | last post by:
Hi, I have table1 and table2, both are linked, and a query has been run. I created forms that use both just the tables, and then another one using just the query. All of the information is there,...
64
by: Mika | last post by:
Hello, we understand you guys may be able to help. We have a page which has been working great for over a year and gets many hits. However recently something got changed that we cannot seem to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.