Can't open any more databases

[Phil Stanton]

Real problem usink AK2

I have got a form with 7 tabs on it, numerous subforms and combo boxes. as
well as continuous subforms with combo boxes. I get the message "Can't open
any more databases" as I move to a tab with yet another subform on it.

Firstly I suspect it means it can't open any more queries or recordsets. Can
anyone confirm this please.
Does anyone know the limit

I think I have done all the right things. Closed and set all recordsets to
nothing after they have been opened in code. Set all Databases to nothing.
Changed all Dlookups to query based ELookups

Any other bright ideas.
Would upsizing to a SQL server help,if so which one

TIA

Phil

[PC Datasheet]

Phil,

I have lots of information regarding this error message - it's too much to
post here. I'd be glad to email it to you in a private email if you send me
your address.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:41*********************@mercury.nildram.net.. .

Real problem usink AK2

I have got a form with 7 tabs on it, numerous subforms and combo boxes. as
well as continuous subforms with combo boxes. I get the message "Can't open any more databases" as I move to a tab with yet another subform on it.

Firstly I suspect it means it can't open any more queries or recordsets. Can anyone confirm this please.
Does anyone know the limit

I think I have done all the right things. Closed and set all recordsets to
nothing after they have been opened in code. Set all Databases to nothing.
Changed all Dlookups to query based ELookups

Any other bright ideas.
Would upsizing to a SQL server help,if so which one

TIA

Phil