[AccessD] Error 3048 Cannot open any more databases

Darryl,

This is a highly misleading message, because it really means you have
too many connections open.  If you are doing things like populating
combo boxes with select statements, each one of them is opening a
connection.  As I recall, lookups in your tables could do that as well.
Access was NOT meant for WAN use, and to make it even marginally
reliable in that context, you have to rewrite the UI to eliminate any
unnecessary connections to the back end and use a JIT approach to
populating lists, forms, subforms, etc.  There have been previous
discussions on this in the list, so you might take a stroll through the
archives and see what you find.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl
Collins
Sent: Tuesday, March 04, 2008 4:23 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Error 3048 Cannot open any more databases



Hey folks,

Sorry to bug you with this, Having a lot of, ummm, 'fun' with this
database I am building. Stand alone, it works great, with 5 or so users
it works great, over a WAN with multi users it gets very wobbly and
corrupts easily.  

Decided that it has to be split into FE and BE, which I have done
manually and linked up the tables. When the DB opens it populates a
listbox with choices for the user as before fine.  However when the
users selects an option which opens the data-entry form (and associated
subforms) I get this lovely error

"Error 3048 Cannot open any more databases"

on this line
sSQL = "SELECT * FROM tbl_FYP_APLID WHERE (((FYPID)=" & lFYPID & ") AND
((tbl_FYP_APLID.APLID)=" & lAPLID & "));"
[Forms]![frm_FYP_APLID].RecordSource = sSQL

Now I know clearly that I must have too "many databases open", but
exactly what the hell does that mean? how did it happen and how can I
either 1: increase the amount of DB's I can have open, or close down
some of the offending databases?

The only clue I have found online is if you don't SET your delcared
CurrentDB to NOTHING when you are done with it, But the code in this
workbook doesn't work like that at all and the modules that do use SET
current DB, does set them to nothing when finished.  Most confusing.

Can anyone shed some light on this. Sorry about all the questions -
working under lot of pressure and learning on the fly.  Educational for
sure, but I am getting through more and more scotch in the evening!!

:) Darryl.