|
       |
|
 |
||||||||||||||||||||||||||||
|
 |
|||||||||||||||||||||||||||
 |
||||||||||||||||||||||||||||
Access Database Problems Summary MS Access has a limit of 255 connections per server, across all sites. Scripts that open many connections, or do not close connections after use, can quickly exceed this limit. Leaving a connection open means that a script has to time out. This can take several minutes - during which time the connection is unavailable to the same, and other, scripts. Espinda' servers support MS Access 2000 and above. You are strongly recommended to use the latest version. Solution When using Access, it is very important to: · Use OLE-DB ("PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=<path to database.mdb>;"); · Open connections only when needed. · Close open connections as early as possible. The connections are on a per server basis, and we cannot control how they are used. |
 |