[AccessD] Error 3048 Cannot open any more databases

Jim Dettman jimdettman at verizon.net
Wed Mar 5 07:52:45 CST 2008


Darryl,

<<over a WAN with multi users it gets very wobbly and corrupts easily.>>

  If this is a JET backend, then your just asking for trouble.  JET was
never designed to run over a WAN and should not be.

<<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?>>

  Access/JET has an internal limit of the number of table references it can
have open.  Along with the table reference is a database reference of course
and that's where the error message comes from.  What's mis-leading though
with this error message is that every field you reference, be it in a combo,
text box, or whatever, each carries a table reference.

  So the bottom line is your in some way shape or form (a combination of
fields, tables and databases you might open in code), you using a little
over 2000 of them and hitting the internal limit.

  There's no "fix" for it other then to reduce the scope of operations that
your doing.  I'd start by double checking on combo's and list boxes that you
reference only the fields you need for the bound column and drop down.  One
technique many use is to pull into the combo/list box all the fields they
need in the form (they just don't display them for the drop down) so they
don't have to write the code to pull the data separately. 

  This technique lets you bump into the internal limit real fast if you use
a lot of combos/list boxes.

Jim. 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Tuesday, March 04, 2008 7: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.


This email and any attachments may contain privileged and confidential
information and are intended for the named addressee only. If you have
received this e-mail in error, please notify the sender and delete this
e-mail immediately. Any confidentiality, privilege or copyright is not
waived or lost because this e-mail has been sent to you in error. It is your
responsibility to check this e-mail and any attachments for viruses.  No
warranty is made that this material is free from computer virus or any other
defect or error.  Any loss/damage incurred by using this material is not the
sender's responsibility.  The sender's entire liability will be limited to
resupplying the material.

-- 
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