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

Can't open any more databases

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.