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