Access Error Message

[sueviolet]

I am using a data entry program and when I enter records on a certain form,

I get the following error message when I enter data in to an Access 2000 database:

************
Microsoft JET Database Engine error '80004005'

Cannot open any more tables.

/m3cat/metd_edit.asp, line 1911
************


Any suggestions on how I can solve this problem?

I have been told my the people that created this program that they don't know what the problem is and I am "on my own" for fixing it.

Thanks!

 

[The_Doc_Man]

There is a limit to the number of things you can have open at once in ANY program 'cause opening something consumes a bit of memory somewhere (to remember a pointer to the open THING, whatever it is.) When you run out of memory, you can't open anything else until you close something.

The reference to .asp makes me think the problem is some code in an .ASP page that opens but doesn't always close what it uses. There is an old programmer's rule that sorta sounds like your Mom from back when you were just a kid. "If ya open it, ya gotta close it again or it'll spoil 'n' stink."

Well, maybe this is not the right answer, but the first place I would look given what you told us is to see if some .ASP pages do some opens for which the corresponding close doesn't always occur.