Weird Error message

[AccessKurzo]

When I click on combo boxes on certain forms, I get a microsoft error:
"Cannot open any more databases."

I've never seen this message before. I am only linked to one database.

Anyone ever seen this? What can I check?

 

[Shep]

You can check for excessive use of domain lookups and for recordsets left open, for starters.

Shep

 

[AccessKurzo]

so, is there a limit as to how many lookups you can have on a form? I use queries to populate combo's and lists - is that what you mean?

 

[Shep]

Yes, there is a limit, though I don't know the exact number or if there is actually a numeric limit.

At any rate, the use of a saved query should not affect this, as far as I know.

If you do not use Recordsets or DLookups then I am at a loss to explain why you are seeing the error.

Edit:
Do you use saved queries or SQL for your combo and list boxes and , how many of these objects are there in your forms?

Shep

 

[The_Doc_Man]

If you have lots of VBA code using Dim dbXYZ as Database, and

If you have lots of different database varibles delared in general modules that stay open for a long time, and

If you do a lot of Set dbXYZ = CurrentDB, but

You don't ever do a dbXYZ.Close, then

That's part of your problem.


The next question: When you get this error message, can you shut down Access, restart it, and go at least as far as you did before, or

when you restart Access, you get the error immediately, or

you have to reboot because you can't even restart Access.

(This latter question is so we can see if some system resource is being consumed and not properly released.)

 

[AccessKurzo]

Thanks for the replies -

I actually had a few dim 'dbs as database' and 'dim rs as recordset'lines, but didnt destroy them

So I just made one global dbs as database and made sure to destroy all recordsets at the end of procedures.

Everything works great now - thanks

 

[AccessKurzo]

I was still getting that error, so I just talked to Microsoft about this -

This message may show up if you have a form that contains many Sub Forms. I had a Main form with 12 tabs - each tab had at least one sub form some had 3 or 4.

I pulled all the sub forms out of there and it works fine now.

 

[Shep]

Thanks for the update. This is very good information.