dave sharpe
davesharpe2 at cox.net
Thu Oct 16 17:05:15 CDT 2003
This might be of interest Comparison of DAO and ADO Recordset Syntax These examples provide DAO programmers with a brief reference to ADO syntax. You are the correct audience for this page if you already know about programming Microsoft's "DAO Recordsets," and are enrolled in MIS 333k using the textbook Beginning Access 2000 VBA, Smith and Sussman, Wrox, 1999. The next generation recordset interface is referred to as ActiveX Data Objects (ADO). It brings a slightly different interface syntax (your DAO knowledge will transfer nicely) and a much more powerful and consistent toolkit for accessing today's variety of PC and mainframe database formats. http://www.utexas.edu/courses/poynor/access2000/sjdaoadorecordsets.html Dave ----- Original Message ----- From: "Elam, Debbie" <DElam at jenkens.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Thursday, October 16, 2003 3:36 PM Subject: [AccessD] ADO CurrentDB() Is there an equivalent of CurrentDB() in ADO? Explicitly defining the place where a database resides is much easier to break. CurrentDB() worked so well in DAO it is hard to believe that an equivalent does not exist. Debbie