The ADOCE Connection Object

Abstract

After two chapters worth of connecting to local Pocket Access databases and executing DDL and DML statements using the Recordset object, you’re probably wondering what you need a Connection object for. You might be surprised to find out that you were using the Connection object all along. Every time you executed a DDL statement or a SQL query with the Recordset object, you also passed along a reference to the Pocket Access database you wanted to communicate with. Due to ADOCE’s flat object model, you were able to use the Connection object implicitly to create a connection each time you used the Recordset object. This is fine when I’m trying to teach you Pocket SQL DDL or DML, but there are good reasons not to operate this way when you’re building a production application.