[AccessD] Runtime error 3048 -- Cannot open anymore databases

Stuart McLachlan stuart at lexacorp.com.pg
Sat Apr 23 16:55:17 CDT 2011


>From everything that I have read, Access maintains TableIDs internally and the number 
currently used is not exposed in any way, so sadly it appears that the answer to your question 
is - You can't.

-- 
Stuart

On 23 Apr 2011 at 5:20, Darrell Burns wrote:

> Howdy. First-time on AccessD.
> 
> I've tried all the other forums and can't get an answer to this one.
> 
> I have a FE A2007 app linked to a BE A2007 database. There's a master
> form with 6 tabs. Each tab contains a subform that's bound to a query.
> Plus I open recordsets on the the BE tables to fetch stuff for the
> form. You can drill down from any subform to a detailed form by
> double-clicking a data field. I started getting the above error
> message after opening 2 or 3 of these forms, so I created a form
> handler method that shuts down the calling form and closes all the DB
> connections before opening the target form. I'm still getting that
> error. I've gone thru my code and diligently set all DBs to nothing at
> the end of each sub, but I can't seem to lick the problem. 
> 
> 
> 
> Suggestions from other forums have been to unbind the tables from the
> subforms. I buy that, but the question I can't get an answer to is how
> can I monitor how many connections I have open at one time so I can
> diagnose the problem? I feel like I'm debugging in the dark.
> 
> 
> 
> Please turn on the light for me.
> 
> 
> 
> Thanx,
> 
> Darrell
> 
> 
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 






More information about the AccessD mailing list