O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Unbound Form

The form used in the first example utilizes a public ADO connection object. This object initializes when the form loads and remains in memory as long as the application is running. You will need to evaluate whether it is more efficient to re-establish the connection repeatedly or to maintain the public connection. Generally, if there are fewer users, the approach shown in this example (a public connection) is more efficient. This is because Access does not need to connect to the server repeatedly. As the number of users increases, you may find that the public connection utilizes excessive server resources. You would then modify the code to have each event routine establish its own local connection.

The code in Listing 13.1 uses ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required