I have a multi-user Access (Version 7.0) database with FE/BE database files...actually three back-ends. One of the "back-end" files contains only 1 table as it is the most dynamic table in the system and with issues of file corruption it made sense to be able just to be able to backup this critically changing data. The other two back-end files are relatively static in their data content and actually aren't even updatable by all end-users except one. The FE and these two relatively static BEs are copied from the server to the user's workstation with the FE being linked appropriately to 1 table on the server with all others linked locally.
Now, my form processes all use unbound text box controls where data is extracted from (using dbOpenSnapshot) and saved to (using OpenDynaset) this 1 dynamic table using recordsets and VBA. I have verified that all recordset processing loops and OnError routines properly close the recordset as data is extracted or saved.
Today, when a single user edited 150-200 records she received error 3048(Can't open any more databases.) I could watch on the NT server as the lock file (.ldb) was constantly appearing, then disappearing as she saved record after record.
Any ideas on what to look for on this particular error? Does anyone know what the threshold is as far as open databases. I don't know how to interpret what this error is really trying to tell me. Is there any type of trappable error (other than the 3048) that I can use to determine how many open databases there are at any given point in time. In my mind... there should never be more than maybe a couple. Thanks in advance for any help you can offer.
-Ump38
Now, my form processes all use unbound text box controls where data is extracted from (using dbOpenSnapshot) and saved to (using OpenDynaset) this 1 dynamic table using recordsets and VBA. I have verified that all recordset processing loops and OnError routines properly close the recordset as data is extracted or saved.
Today, when a single user edited 150-200 records she received error 3048(Can't open any more databases.) I could watch on the NT server as the lock file (.ldb) was constantly appearing, then disappearing as she saved record after record.
Any ideas on what to look for on this particular error? Does anyone know what the threshold is as far as open databases. I don't know how to interpret what this error is really trying to tell me. Is there any type of trappable error (other than the 3048) that I can use to determine how many open databases there are at any given point in time. In my mind... there should never be more than maybe a couple. Thanks in advance for any help you can offer.
-Ump38