MS Access, Access ADO vs. DAO

Access ADO vs. DAO

Author	Message
Bria #1 / 3	Access ADO vs. DAO Where can I find out information about how to declare the RECORDSET variable in Acess 2000? I have never been able to use my Access 97 database modules in Access 2000, because Access 2000 does not recognize ANY RECORDSET commands (it does not even know what "dbOpenSnapshot" and "dbOpenDynaset" mean). The only way I get them to work is copying the Access 97 dll for ADO over and referencing it. Does Access 2000 not come with any commands which support RECORDSETs? Is there something I must do differently? Suppiose I did not have access to the 97 dlls required for RECORDSETS, how would I connect to a recordset using Access 2000 VBA? -Brian
Sun, 19 Sep 2004 22:22:23 GMT

Manxma #2 / 3	Access ADO vs. DAO Quote: >Where can I find out information about how to declare the >RECORDSET variable in Acess 2000? I have never been able >to use my Access 97 database modules in Access 2000, >because Access 2000 does not recognize ANY RECORDSET >commands (it does not even know what "dbOpenSnapshot" >and "dbOpenDynaset" mean). The only way I get them to work >is copying the Access 97 dll for ADO over and referencing >it. >Does Access 2000 not come with any commands which support >RECORDSETs? Is there something I must do differently? >Suppiose I did not have access to the 97 dlls required for >RECORDSETS, how would I connect to a recordset using >Access 2000 VBA? >-Brian as a first step, Access 2000 will not automatically recognize DAO. go into a VBA module and on the Tools menu go to References. Find the DAO entry (usually 3.6) and check it. Then exit that and go back into it and move the DAO reference above the ADO one ---------------- Richard "ManxMan" Killey www.comeandread.com/access visit my site for tips
Sun, 19 Sep 2004 22:53:05 GMT

John Vinso #3 / 3	Access ADO vs. DAO Quote: >Where can I find out information about how to declare the >RECORDSET variable in Acess 2000? Right here... <g> A2000 defaults to the newer ADO model, but the DAO model is still available. Edit any module; select Tools... References; uncheck the ActiveX Data Objects reference; and scroll down until you find Microsoft DAO 3.6 Object Library (or the highest-numbered version there). Check it, and you'll be back in familiar territory. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public
Mon, 20 Sep 2004 01:58:00 GMT

Page 1 of 1

[ 3 post ]