Access Database Problems

MyEspinda! .Customers Login Here

Documentation

Matrix Stats

Overview

Using MatrixStats

Administration Menu

Scripting and Databases

Sending mail using a script

Scripting JMail with ASP

Scripting JMail with Perl

Scripting CDONTS with ASP

Scripting Access with Perl

Scripting Access with ASP

DSNLESS database usage

Access Database Problems

Using Excel Spreadsheet

Redirection Scripts

Ready to use Hit Counter

Ready to use Form2Mail

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.