Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 8th, 2008, 10:43 PM
Registered User
 
Join Date: Jan 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to faridrd
Default Using DAO and ADO within ADODB.connection

hi,

   I am currently converting an access 97 front end and back end .... to a access 2003 front end sql server back end. Access 97 uses solely DAO recordset object. For the access 2003 i need to change some of the recordsets to use ADO as some of the functions does not seem to work using DAO. Currently I only changed part of the codes as shown below:



Previously : Main Function{



                       DAO recordset

                              wrkspace.begintrans

                                DAO recordset


                                      FUnction{

                                             DAO recordset}


                                     Function{
                                             DAO recordset}



                                DAO recordset
                                wrkspace.commitrans





}



Currently : Main Function{



                       ADO recordset

                              con.begintrans

                                ADO recordset


                                      FUnction{

                                             ADO recordset}


                                     Function{
                                             DAO recordset}



                                ADO recordset
                                con.commitrans





}



Currently my main concern is to just make the system work so i only change the codes when it creates error. The program is able to work fine, its just that I want to noe in case and error occur withing the main function and con.rollback is activated would it rollback whatever is done using DAO.Assuming every function updates a recordset?







Similar Threads
Thread Thread Starter Forum Replies Last Post
how to convert this DAO connection code to ADO Con ruth26 VB Databases Basics 0 May 11th, 2006 05:15 AM
Dao to Ado vrtviral Access VBA 5 February 19th, 2005 11:13 AM
ADO,DAO,ADODB,DB.... ToSupremacy Access 5 February 1st, 2005 01:09 AM
Convert ADO connection to DAO database dr_morose Access VBA 0 November 17th, 2004 05:44 PM
ADO vs DAO perrymans BOOK: Expert One-on-One Access Application Development 0 October 24th, 2004 11:36 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.