Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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 September 15th, 2005, 06:16 PM
Registered User
Join Date: Sep 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts

Hi, guys here:

Thank you so much for all your kind replies. You are so helpful.

After testing, I still have the question to JpJoe.
If I priorities DAO above ADO, does it mean I'm using DAO. Since I need a multi-user environment, actually I have split my database and have a backend and several frontends, do you think ADO is suitable for me? In that case, I'm wondering if there is potential problems with DAO + ADO in the future?

Right now, I prefer to use ADO + DAO (priority my ADO above DAO), since explicitly declare works well. But I don't know if there is other problems or trouble down the road.

For Loralee, you are right, I'm learning through the sample in that book:)

Both the sample code and the code provided by Dartcoach work well with only DAO reference, and also work well after explictly declare with ADO + DAO.

But as you say, I always want to learn. If convenient, please email yours to me. Thanks a lot!

Again, I really appreciate all the help and your time.

Old September 16th, 2005, 06:50 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

DAO can be a problem if you want to move your application anywhere. You will need to visit all your users machines and set the DAO reference. That can be a pain. I have moved off of DAO to prevent this from being an issue. My users are blocks away sometimes.

Old September 17th, 2005, 03:18 PM
Friend of Wrox
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post

Thank you!

Old September 17th, 2005, 07:43 PM
Friend of Wrox
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post

One more question.....

By using the recordsetclone of the recordset, am I really gaining anything over using the recordset directly ?

(Couldn't the same thing be accomplished either way?)


Similar Threads
Thread Thread Starter Forum Replies Last Post
Intelligent Complaint-need help please rsearing Forum and Wrox.com Feedback 1 October 12th, 2006 08:45 AM
Wizard generated navigation buttons mgirard BOOK: Access 2003 VBA Programmer's Reference 3 January 11th, 2005 02:33 AM
Navigation buttons terry s Dreamweaver (all versions) 3 August 3rd, 2004 04:03 PM
Intelligent Navigation Buttons twsinc Access VBA 1 October 7th, 2003 09:07 AM
Animated Buttons Inside Navigation Bars? Ben Horne Dreamweaver (all versions) 0 October 5th, 2003 09:59 PM

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