Tom Bolton
tom.bolton at donnslaw.co.uk
Thu Feb 10 02:58:26 CST 2005
Hear hear! I've found this too - not having used DAO for years I shied away from it when returning to an Access project but it's noticeably quicker when using it for native Access objects. Access was after all designed around DAO/Jet. I can't stress enough what Charlotte said: if you use a mixture of DAO and ADO, REFERENCE THEM EXPLICITLY! (ADODB.Recordset, DAO.Database etc.) You'll be in a whole world of pain otherwise. Cheers Tom -----Original Message----- From: Bobby Heid [mailto:bheid at appdevgrp.com] Sent: 09 February 2005 19:27 To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Question on Reference (DAO) It is my understanding that when accessing native Access databases, that DAO is the best performer. If you will be accessing SQL Server or other OLE databases, use ADO. Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark Sent: Wednesday, February 09, 2005 1:51 PM To: accessd at databaseadvisors.com Subject: [AccessD] Question on Reference (DAO) I am working on a new program in A2K. Most of my older existing stuff is A97, and I just used some old code which had a problem. Basically, I took some code I was using, from an A97 db, to add items to a combo on NotInList...I think the code was originally written by Dev Ashish. I got a "reference" error, so I went into the references and added Microsoft DAO 3.6 object library, and it is working now. My question is this; is this alright, or should I have adapted the code to fit 2K? Is there any penalty that I risk (i.e. speed, etc.) by keeping it this way? Thanks, John W Clark -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- The contents of this message and any attachments are the property of Donns Solicitors and are intended for the confidential use of the named recipient only. They may be legally privileged and should not be communicated to, or relied upon, by any other party without our written consent. If you are not the addressee, please notify us immediately so that we can make arrangements for its return. You should not show this e-mail to any person or take copies as you may be committing a criminal or civil offence for which you may be liable. The statement and opinions expressed in this e-mail message are those of the writer, and do not necessarily represent that of Donns Solicitors. Although any files attached to this e-mail will have been checked with virus protection software prior to transmission, you should carry out your own virus check before opening any attachment. Donns Solicitors does not accept any liability for any damage or loss which may be caused by software viruses...