 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / October 2004My BE does not open two forms at the same time
Hi, i just splitted my multi-user database (access 2003) into a front end and back end. It's a very complexe database, size about 50mb, and about 150 queries and reports. If I open in the FE a very complexe formular and want to open another form, access failures: More Datebases cannot be openend!! I have only one database! If I open the second form first and then open the very complexe formular, access works fine. There is no relationship between these two forms. I read the whole multi-user section in the newsgroups, but didn't find so with the same problem! It would be very pleasant for me, if anybody could help me! Matthias The Error is named: 3048 Matthias >Hi, > [quoted text clipped - 17 lines] >Matthias >. Hi, Matthias. Error #3048 is usually caused by your database application trying to handle too many tables at the same time. There are 2048 "table handles," or TableID's, available for Jet 3.51 and 4.0 (1024 TableID's for Jet 3.0 and 3.5) that Access requires when dealing with each table or linked table. TableID's are used for the following: - Tables - Queries - Bound forms and reports - Modules for forms and reports - Combo boxes and list boxes whose row source is a table or query - Data Access Objects (DAO) Recordsets in code - Domain functions, such as DLookup( ), DCount( ), et cetera. If this error is caused by the application using too many TableID's, then ensure that every Recordset used in code is explicitly closed and the Recordset variable set to Nothing before the variable goes out of scope. If this is occurring only after the report is opened multiple times, then you'll likely fix the problem by explicitly closing and setting objects to Nothing in at least one code module. If this isn't enough to prevent the error message from recurring, then the alternatives are to reduce the number of combo boxes that meet the above listed criteria, simplify complex queries, or to unlink some of the tables (linked tables require twice as many TableID's) and place these tables in the database file. Reducing the number of any of the items on the list above will help reduce the number of TableID's in use. The important thing to remember is the total number of TableID's in use at the same time needs to be prevented from exceeding the limit. This error has also been reported to be caused by implicitly referring to the value of a checkbox in an If...Then block statement. If this is the case, then the solution is to explictly refer to this value, instead. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips. (Please remove ZERO_SPAM from my reply E-mail address, so that a message will be forwarded to me.) > Hi, > [quoted text clipped - 16 lines] > > Matthias Hi Gunni, thanks for help. is there any way to get known of the number of used tableIDs? is it possible to increase the maximum number of tableIDs? Matthias >-----Original Message----- >Hi, Matthias. [quoted text clipped - 68 lines] > >. Hi, Mattias. > is there any way to get known of the > number of used tableIDs? Not really. One can estimate how many are being used, though. A TableID is used for each table, each form, each form's module, each table listed in a query, multiple TableID's for each subform with master and child links (depending upon the complexity of the query used), two TableID's for each linked table, and so on. > is it possible to increase the maximum number of tableIDs? If one is using Access 97 prior to SR-1 being installed, then installing this service release or a later one will increase the number of TableID's from 1024 to 2048. Upgrading from Access 95 or earlier to a later version of Access (Jet, really) will increase the the number of TableID's to 2048. 2048 is the maximum number of TableID's that can be used simulataneously for the later versions of Jet. There's no way to increase this limit, though. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips. (Please remove ZERO_SPAM from my reply E-mail address, so that a message will be forwarded to me.) > Hi Gunni, > [quoted text clipped - 106 lines] > > > >. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.