[AccessD] Question on Reference (DAO)

Bobby Heid bheid at appdevgrp.com
Wed Feb 9 13:27:23 CST 2005


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




More information about the AccessD mailing list